August 9, 2013 at 11:00 am
I would like to know here that .. Is there any possiblity to hide SQL Server Instances... Please clarify me.
Thanks in advance !!!
August 9, 2013 at 11:48 am
I'm not completely sure what you mean by "hide" but here's some things to think about:
1. In the SQL Server Configuration Manager you can "hide" the instance from being enumerated by a UDP broadcast request. Expand the entry for 'SQL Server XXXX Network Configuration', find your instance under 'Protocols for <instancename>' and right click. Choose 'Properties'. Under the 'Flags' tab, toggle 'Hide Instance'. http://msdn.microsoft.com/en-us/library/ms179327%28v=sql.100%29.aspx
2. You can also change the default port number in a similar manner. Under the 'SQL Server XXXX Network Configuration' entry, single click your instance. THis will bring up a list of protocols in the left hand window. Right click the 'TCP/IP' protocol and choose 'Properties'. Under the 'IP Addresses' tab you can change your port number. This method is also useful for changing a dynamically allocated port for a named instance to a port of your choosing. Check this article for more information http://www.sqlservercentral.com/articles/Port/75740/[/url]
3. Disabling the SQL Server Browser service will add another layer of obscurity to your instances. Check here for more info http://msdn.microsoft.com/en-us/library/ms181087%28v=SQL.105%29.aspx
HTH
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply