Microsoft Knowledge Base Email Alertz

(896520) - Describes a problem that occurs when the SQL Server client uses shared memory to connect to the MOM 2005 database.

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 896520 - Last Review: November 16, 2007 - Revision: 1.6

You may receive an "Old format or invalid type library error when processing MOM data" message when the Microsoft Operations Manager (MOM) 2005 Management Server and the MOM 2005 database reside on the same computer

SYMPTOMS

When the Microsoft Operations Manager (MOM) 2005 Management Server and the MOM 2005 database reside on the same computer, you may receive the following error message every 24 to 120 hours:
Old format or invalid type library error when processing MOM data

CAUSE

This problem is caused by a memory leak that occurs in the Microsoft SQL Server shared memory protocol file (Dbmslpcn.dll). This file resides on the MOM 2005 Management Server. The Dbmslpcn.dll file contains the connection library protocols that the SQL Server client uses to connect to the MOM 2005 database that is hosted by SQL Server.

The SQL Server client can use the following three protocols to connect to the MOM 2005 database:
  • TCP
  • Named pipes
  • Shared memory
The SQL Server connection library typically contains these three protocols.

By default, a SQL Server client uses the shared memory protocol to connect to the MOM 2005 database when the following conditions are true:
  • The MOM 2005 Management Server is a SQL Server client.
  • The MOM 2005 Management Server resides on the computer that hosts the MOM 2005 database.
However, a memory leak may occur if the following conditions are true:
  • The Dbmslpcn.dll file that is used by the SQL Server client on the MOM 2005 Management Server is not the same version as the SQL Server Ssmslpcn.dll file.
  • The SQL Server client uses the shared memory protocol to connect to the MOM 2005 database.
Note When the SQL Server client and the MOM 2005 database reside on different computers, the TCP/IP or named pipes protocol is used to communicate.

WORKAROUND

To work around this problem, disable shared memory communication by using the Server Network Utility. To do this, follow these steps:
  1. Verify that all instances of Microsoft SQL Server 2000 are version 8.0.818.0 or a later version. To do this, follow these steps:
    1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
    2. Select your SQL Server name and your authentication type, and then click OK.
    3. In the query input window on the Grids tab of the Query dialog box, type the following text, and then press the F5 key:
      SELECT @@version
    4. Verify the version in the results box. If the version is earlier than 8.0.818.0, upgrade Microsoft SQL Server to version 8.0.818.0 or a later version.
  2. Log on to the MOM 2005 Management Server by using an account that has administrative credentials.
  3. Click Start, point to Programs, point to Microsoft SQL Server, and then click Server Network Utility.
  4. In the Server Network Utility dialog box, click the General tab.
  5. On the General tab, make sure that only the TCP/IP and Named Pipes protocols are listed in the Enabled protocols list, and then click OK.

STATUS

Microsoft has confirmed that this is a bug in SQL Server 2000.

MORE INFORMATION

For information about the most recent Microsoft SQL Server 2000 updates, visit the following Microsoft Web site:
http://technet.microsoft.com/en-us/sqlserver/bb331754.aspx (http://technet.microsoft.com/en-us/sqlserver/bb331754.aspx)

APPLIES TO
  • Microsoft Operations Manager (MOM) 2005
  • Microsoft SQL Server 2000 Service Pack 3
Keywords: 
kbtshoot kbprb KB896520
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate