Microsoft KB Archive/296041

= Optimizing SQL Protocols for Microsoft Operations Manager 2000 =

Article ID: 296041

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Operations Manager 2000 Service Pack 1

-



This article was previously published under Q296041



SYMPTOMS
Microsoft Operations Manager 2000 (MOM) requires the use of named pipes to facilitate communications with the SQL server that hosts the MOM database. If named pipes are not enabled on the SQL server, communication between the Consolidator-Agent Manager and the Data Access Server is adversely affected. In addition to named pipes, MOM also requires TCP/IP for database communications.



RESOLUTION
To configure the SQL server to use TCP/IP and named pipes, use the Client Network Utility on DCAM computers and the Server Network Utility on the SQL server to modify the order of the Network Library. For best performance, TCP/IP should be first, followed by named pipes. This procedure must be performed on all computers that act in the role of a DCAM.

To modify the Network Library on the SQL server:  Click Start, point to Programs, point to Microsoft SQL Server, and then click Server Network Utility. Confirm that TCP/IP and Named Pipes are displayed in the Enabled Protocols box, and if they are not:  Click TCP/IP library in the Disabled Protocols box, and then click Enable. Click Named Pipes library in the Disabled Protocols box, and then click Enable. 

To modify the Network Library on a remote DCAM:  Click Start, click Run, type cliconfg, and then click OK.</li> On the General tab, confirm that TCP/IP and Named Pipes are displayed in the Enabled Protocols box, and if they are not:  Click TCP/IP library in the Disabled Protocols box, and then click Enable.</li> Click Named Pipes library in the Disabled Protocols box, and then click Enable.</li></ol> </li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbenv kbprb KB296041

-

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

© Microsoft Corporation. All rights reserved.