重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 516|回复: 0

[工具] em13c 发现SQLSERVER失败:报 "Cant find the key“

[复制链接]
发表于 2024-6-11 15:34:24 | 显示全部楼层 |阅读模式
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\



回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-12-4 18:09 , Processed in 0.082924 second(s), 21 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表