Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
BUG: Hide Server Option Cannot Be Used on Multiple Instances of SQL Server 2000
Article ID: 308091 - View products that this article applies to.
This article was previously published under Q308091
The Server Network utility allows the network protocols on which SQL Server listens to be enabled or disabled. The Server Network utility also provides a way to configure the properties of each protocol. One of the properties for TCP/IP is the option to hide an instance of SQL Server that is installed on the computer. SQL Server 2000 Books Online contains the following information about hiding an instance of 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.To hide an instance of SQL Server:
An instance of SQL Server 2000 is automatically set to listen on port 2433 and this cannot be modified. If you attempt to reset the port number through the Server Network Utility, the change takes affect and is updated in the registry. However, when you restart the SQL Server 2000 instance, the port number is automatically set back to 2433.
You must disable the Hide Server option on one of the SQL Server instances to allow the server to listen on TCP/IP.
If you attempt to enable the Hide Server option on multiple SQL Server 2000 instances that are installed on one computer, only one of the instances is able to listen on TCP/IP. The first instance to come online grabs port 2433. All subsequent instances are not able to obtain port 2433. The following error message is written to the SQL Server error log:
SuperSocket Info: Bind failed on TCP port 2433
If you subsequently disable the Hide Server option, the port on which SQL Server listens remains at 2433. You must manually make a change to reflect a new TCP port.