Optimizing SQL Protocols for Microsoft Operations Manager 2000 (296041)
The information in this article applies to:
- Microsoft Operations Manager 2000
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.
- 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.
- Click Named Pipes library in the Disabled Protocols box, and then click Enable.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Minor | Last Reviewed: | 6/13/2005 |
|---|
| Keywords: | kbenv kbprb KB296041 |
|---|
|