SQL Server 2000 Network Utility

If you are wondering (or like me you forgot) where to enable / disable the various Network Protocols within SQL Server 2000, type “svrnetcn.exe” from the “Start => Run” menu on the Server that is hosting the SQL Instance.

svrnetcn 001

This brings up the “SQL Server Network Utility”

svrnetcn 002

For remote connections to the server, “TCP/IP” should be enabled. Use the “Properties” box to adjust the “Default Port Number” if necessary.

svrnetcn 004

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s