Hiding the Server on the Network

When you install SQL Server, setup makes an entry in the Windows NT Registry so that named pipe clients can see the SQL Server in a server enumeration box, such as those that appear in ISQL/w. If you want to hide the server on the network, you must set a switch using the Network application in the Windows NT Control Panel.

When a server is hidden, named pipe clients can still connect to it, but they cannot see it when viewing servers.

    To hide a server from named pipe clients

1. Open the Main program group and double-click the Control Panel icon.

   The Control Panel window appears.

2. Double-click the Network icon.

   The Network Settings dialog box appears.

   

3. From the list in the Installed Network Software box, select Server.
4. Choose the Configure button.

   The Server dialog box appears.

   

5. Clear the Make Browser Broadcasts to LAN Manager 2.x Clients check box.
6. Choose the OK button.

   The Network Settings dialog box returns.

7. Choose the OK button again.

   For named pipe clients, the server is hidden.

You can reveal the server later by running the Network application and selecting the Make Browser Broadcasts to LAN Manager 2.x Clients check box.