Microsoft KB Archive/166196

= SMS Setup Requires SQL Server Named Pipes Network Support =

Article ID: 166196

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 1.0 Standard Edition
 * Microsoft Systems Management Server 1.1 Standard Edition
 * Microsoft Systems Management Server 1.2 Standard Edition

-



This article was previously published under Q166196



SYMPTOMS
SQL Server Named Pipes network support is required for Systems Management Server Setup to communicate with the SQL Server that stores the Systems Management Server database. Systems Management Server utilities and services use Named Pipes by default, and may have problems connecting to the Systems Management Server database if SQL Server is configured incorrectly. For example, if Named Pipes network support is not loaded, the Systems Management Server Administrator program may fail to start up, and produce the error message, "Unable to Connect to SQL Server."

You can change the SQL Server network support option by running SQL Server Setup, selecting Change Network Support, and then selecting Named Pipes as an installed network.

If you use multiple SQL Server networks, it is recommended that you set Named Pipes as the default network. You can configure this on the Net Library Settings tab of the SQL Server Client Configuration Utility.



STATUS
Microsoft has confirmed this to be a problem in Systems Management Server version 1.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: prodsms sockets

Keywords: kbbug kbdatabase kbinterop kbnetwork kbpending kbsetup kbsmsadmin KB166196

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.