How can I configure SQL Server to listen on another net-lib? How can I tell what net-libs are being used?

A. For SQL 6.5 and earlier run SQL setup and choose 'Configure Server' and then 'Network Support'. This will tell you what net-libs are installed and allows you to configure new ones.

For SQL 7.0 and above there is a "Server Network Utility" installed in the SQL Server program group that performs the same function.

For all versions of SQL Server you can check the SQL errorlog for "listening on" lines which tell you what net-libs are being used.


Please or Register to post comments.

Upcoming Training

Mastering System Center 2012

During over 6 hours of training you can join John Savill from your computer as he will walk you through the key components and capabilities of System Center 2012, what’s involved in using the components, and the benefit they can bring to your environment.

Register Now

Current Issue

May 2013 - The NameTranslate object is useful when you need to translate Active Directory object names between different formats, but it's awkward to use from PowerShell. Here's a PowerShell script that eliminates the awkwardness.

CURRENT ISSUE / ARCHIVE / SUBSCRIBE

Windows Forums

Get answers to questions, share tips, and engage with the Windows Community in our Forums.