em13c 发现SQLSERVER失败：报 "Cant find the key“

郑全

MS SQL Discovery fails with "Cant find the key : SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL\\MSSQLServer" (Doc ID 743762.1)

In this Document

Symptoms

Cause

Solution

References

APPLIES TO:

Enterprise Manager for Miscellaneous Plug-ins - Version 3.1 to 3.3.3.1.0

Microsoft Windows x64 (64-bit)

z*OBSOLETE: Microsoft Windows XP (64-bit Itanium)

Microsoft 64-bit Windows XPMicrosoft Windows Server 2003 (64-bit AMD64 and Intel EM64T)

SYMPTOMS

MS SQL server database discovery fails with following error from the console:

Warning

Failed to contact the target to be added. Following errors were received while testing the connection to the target. Update the properties accordingly, try Test Connection for testing the properties before saving.

_MSSQL_DataRoot_DynamicProperty - Cant find the key : SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL\\MSSQLServer

Add Microsoft SQL Server

Following errors are found in emagent.trc

2008-08-25 09:26:26,942 Thread-5144 ERROR : (nmectc.c,1060):Memory 0x0 encountered, expect

struct_id=11001

2008-08-25 09:26:26,942 Thread-5144 WARN engine: cannot find metricColl for

[phwcorpfinsql.dhe.duke.edu, microsoft_sqlserver_database, _MSSQL_DataRoot_DynamicProperty]

2008-08-25 09:26:27,943 Thread-5144 ERROR fetchlets.oslinetok: Process stdout = Cant find the key: SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL\\MSSQLServer

CAUSE

32 bit MS SQL program/binaries are installed on 64 Bit Windows machine which is not supported by current version 8 of plug-in (3.3.3.1).

Unpublished enhancement request Bug 7351884 SUPPORT OF MONITORING OF 32-BIT SQL SERVER INSTANCE INSTALLED ON 64-BIT

Bug 7384061 CANT FIND THE KEY : SOFTWARE\MICROSOFT\MICROSOFT SQL SERVER\INSTANCE NAMES\SQL\

SOLUTION

If 32 bit MS SQL server is installed on 64 bit machine then you are running into this issue. Currently monitoring 32 Bit MS SQL server on 64 bit machine is not supported by latest release of plug-in version 8. This is going to be supported from next release of plug-in version 9 which is due on end of December 2008.

REFERENCES

BUG:7384061 - CANT FIND THE KEY : SOFTWARE\MICROSOFT\MICROSOFT SQL SERVER\INSTANCE NAMES\SQL\