Sunday, February 26, 2012

Hiding SQL server

I'm trying to hide a SQL server, to prevent anyone from knowing it exists. I
checked the option 'Hide server' in the server network utility, however, whe
n
adding a new SQL server registration in Enterprise manager on another machin
e
then clicking the browse button, my hidden server is happily displayed.
Any ideas on how to effectively hide the server?Disable access to UDP port 1434. What are you really trying to hide though,
people can still scan and find tcp 1433 unless you change that too...
"HALi" <HALi@.discussions.microsoft.com> wrote in message
news:FB25C73B-1794-4743-872A-A2C8FD9016F4@.microsoft.com...
> I'm trying to hide a SQL server, to prevent anyone from knowing it exists.
> I
> checked the option 'Hide server' in the server network utility, however,
> when
> adding a new SQL server registration in Enterprise manager on another
> machine
> then clicking the browse button, my hidden server is happily displayed.
> Any ideas on how to effectively hide the server?|||Firewall it.
I administered an HR server and that was firewalled. Only 1433 was
opened and only certain IP addresses on the network was allowed to
connect to the machine - my workstation being one of them.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
HALi wrote:
> I'm trying to hide a SQL server, to prevent anyone from knowing it exists.
I
> checked the option 'Hide server' in the server network utility, however, w
hen
> adding a new SQL server registration in Enterprise manager on another mach
ine
> then clicking the browse button, my hidden server is happily displayed.
> Any ideas on how to effectively hide the server?

No comments:

Post a Comment