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\