Hi All:
Does anyone know where to find the property that disables the broadcast of the sql server from the point where you do not see the server show up in the list when one goes to
"New SQL Server Registration" -> "..."
beside the "Server" field. The dialog itself is titled "Registered SQL Server Properties". Assume both SQL Servers are both behind the firewall.While it isn't 100%, you can get a good start by disabling the Named Pipes Broadcast (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_97cb.asp) for SQL Server.
-PatP|||Thanks for the reg key option. For some reason I seemed to remember seeing an option where you can set this from the enterprise UI. I could be wrong but does anyone remember anything along those lines.|||Thanks for the reg key option. For some reason I seemed to remember seeing an option where you can set this from the enterprise UI. I could be wrong but does anyone remember anything along those lines.
Start->Programs->SQL Server->Server Network Utility; in the General Tab, select TCPIP. Select Properties, Check the option HIDE SERVER.
it would force SQL stop broad casting the port it's listening to.|||Start->Programs->SQL Server->Server Network Utility; in the General Tab, select TCPIP. Select Properties, Check the option HIDE SERVER.
it would force SQL stop broad casting the port it's listening to.I think that is only a choice for named instances of SQL Server.
-PatP|||I think that is only a choice for named instances of SQL Server.
-PatP
Hi. This is what BOL says.
[Hide server
Select to hide the instance of Microsoft SQL Server. When you hide an instance of SQL Server, responses to broadcasts from clients attempting to enumerate those instances of SQL Server present on the network are disabled.]
named instance is not exclusively mentioned; have to test the scenario
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment