What Is SQL Server Network Utility?

SQL Server Network Utility is a graphical tool that allows you to:

•	Load network protocols installed on the server so they are actively listening for client connections.

•	Display information about the network libraries currently installed on the server.

•	Configure connection parameters for network protocols.

For more information about SQL Server Network Utility, see Managing Servers in Microsoft® SQL Server™ Books Online.

Note

When you change the network configuration on the server side, you must also check to be sure that the client is using the same network configuration. Use SQL Server Client Network Utility to configure the client.


General Tab

This table shows the options and their functions available on the General tab.

Use this	To do this
Server network library	Indicate the server network library to use for the configuration entry.
Connection parameters	Indicate any parameters associated with the connection address for the network library configuration.
Add	Load an installed network library.
Remove	Deactivate a network library configuration.
Edit	Edit a network library configuration.
Enable SNMP	Enable Simple Network Management Protocol, with which you can monitor Microsoft® SQL Server™ across different platforms (for example, Microsoft Windows NT®, and UNIX).
See Also

How to load an installed network library	How to deactivate a network library configuration
How to edit a network library configuration


Network Libraries Tab

This table shows the options and their functions available on the Network Libraries tab.

Use this	To do this
Server network library	List the Microsoft® SQL Server™ client network libraries installed on this computer.
Library file name	List the location of the SQL Server client network libraries installed on this computer.
Version	List the version numbers of the SQL Server client network libraries installed on this computer.
File date	List the dates that the SQL Server client network libraries were installed on this computer.
Size	List the file sizes of the SQL Server client network libraries installed on this computer.
See Also

How to view the installed SQL Server server network libraries


Add (or Edit) Library Configuration

This table shows the options and their functions available in the Add (or Edit) Library Configuration dialog box.

Use this	To do this
Server name	Specify the name of the server running Microsoft® SQL Server™ that uses the Named Pipes network library to listen for clients.
Network libraries	Specify the network library that will be used to listen for clients. Named Pipes is selected.
Pipe name	Specify the pipe on which SQL Server listens. By default, SQL Server listens on the standard pipe,  \\.\pipe\sql\query.
See Also

How to load an installed network library	How to edit a network library configuration


Add (or Edit) Library Configuration

This table shows the options and their functions available in the Add (or Edit) Library Configuration dialog box.

Use this	To do this
Server name	Specify the name of the server running Microsoft® SQL Server™ that uses the TCP/IP Sockets network library to listen for clients.
Network libraries	Specify the network library that will be used to listen for clients. TCP/IP is selected.
Computer name	Specify the computer that listens for TCP/IP Sockets clients.
Port number	Specify the TCP/IP port that the server listens on when accepting connections from TCP/IP Sockets clients. The default is 1433.
Proxy address	Specify the proxy server’s address if you set the server to listen on a proxy server using Microsoft Proxy Server.
See Also

How to load an installed network library	How to edit a network library configuration


Add (or Edit) Library Configuration

This table shows the options and their functions available in the Add (or Edit) Library Configuration dialog box.

Use this	To do this
Server name	Specify the name of the server running Microsoft® SQL Server™ that uses the multiprotocol network library to listen for clients.
Network libraries	Specify the network library that will be used to listen for clients. Multiprotocol is selected.
Computer name	Specify the computer that listens for multiprotocol clients.
Enable multiprotocol encryption	Specify that multiprotocol encryption should be used for password authentication and data.
See Also

How to load an installed network library	How to edit a network library configuration


Add (or Edit) Library Configuration

This table shows the options and their functions available in the Add (or Edit) Library Configuration dialog box.

Use this	To do this
Server name	Specify the name of the server running Microsoft® SQL Server™ that uses the NWLink IPX/SPX network library to listen for clients.
Network libraries	Specify the network library that will be used to listen for clients. NWLink IPX/SPX is selected.
Specify parameters by	Indicate how parameters are specified. Service name is selected.
Service name	Specify the Microsoft Windows NT® computer name that SQL Server is running under. This information is stored in the bindery of the server.
See Also

How to load an installed network library	How to edit a network library configuration


Add (or Edit) Library Configuration

This table shows the options and their functions available in the Add (or Edit) Library Configuration dialog box.

Use this	To do this
Server name	Specify the name of the server running Microsoft® SQL Server™ that uses the NWLink IPX/SPX network library to listen for clients.
Network libraries	Specify the network library that will be used to listen for clients. NWLink IPX/SPX is selected.
Specify parameters by	Indicate how parameters are specified. Network address is selected.
Address	Specify the MAC address.
Port	Specify the socket number.
Network	Specify the NetWare network number.
See Also

How to load an installed network library	How to edit a network library configuration


Add (or Edit) Library Configuration

This table shows the options and their functions available in the Add (or Edit) Library Configuration dialog box.

Use this	To do this
Server name	Specify the name of the server running Microsoft® SQL Server™ that uses the AppleTalk network library to listen for clients.
Network libraries	Specify the network library that will be used to listen for clients. AppleTalk is selected.
Object name	Specify the service object assigned by your system administrator. See your system administrator for this value.
Zone	Specify the zone used when registering the service.
See Also

How to load an installed network library	How to edit a network library configuration


Add (or Edit) Library Configuration

This table shows the options and their functions available in the Add (or Edit) Library Configuration dialog box.

Use this	To do this
Server name	Specify the name of the server running Microsoft® SQL Server™ that uses the Banyan VINES network library to listen for clients.
Network libraries	Specify the network library that will be used to listen for clients. Banyan VINES is selected.
Service	Specify the StreetTalk PC-based service name used by the server.
Group	Specify the group to which the service belongs.
Organization	Specify the organization to which the group belongs.
See Also

How to load an installed network library	How to edit a network library configuration


How to start the SQL Server Network Utility (Network Utility)

To start the SQL Server Network Utility

•	On the Start menu, point to Programs/Microsoft SQL Server 7.0, and then click Server Network Utility.


How to load an installed server network library (Network Utility)

To load an installed server network library

1.	On the Start menu, point to Programs/Microsoft SQL Server 7.0, and then click Server Network Utility.

2.	In the SQL Server Network Utility dialog box, click Add.

3.	In the Add Network Library Configuration dialog box, specify the server name to load an installed server network library on.

4.	Select the server network library to load. Depending on which server network library you are loading, you may need to specify any necessary connection parameters.


How to deactivate a server network library configuration (Network Utility)

To deactivate a server network library configuration

1.	On the Start menu, point to Programs/Microsoft SQL Server 7.0, and then click Server Network Utility.

2.	In the SQL Server Network Utility dialog box, select the server network library configuration to deactivate, and then click Remove.


How to edit a server network library configuration (Network Utility)

To edit a server network library configuration

1.	On the Start menu, point to Programs/Microsoft SQL Server 7.0, and then click Server Network Utility.

2.	In the SQL Server Network Utility dialog box, select the server network library configuration to edit, and click Edit.

3.	In the Edit Network Library Configuration dialog box, change the server name or parameters to edit.


How to view the installed SQL Server server network libraries (Network Configuration)
How to view the installed SQL Server server network libraries (Network Utility)

To view the installed SQL Server server network libraries

1.	On the Start menu, point to Programs/Microsoft SQL Server 7.0, and then click Server Network Utility.

2.	In the SQL Server Network Utility dialog box, click the Network Libraries tab. The installed SQL Server server network libraries will be displayed.


See SQL Server Books Online to review this topic.