Enabling snmp - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Enabling snmp

Author

Topic

lkd7
Starting Member

4 Posts

Posted - 2005-02-22 : 10:52:59

Hello,

We didn't have the Windows SNMP component installed when we installed MS SQL. The SNMP service is now installed and running, and I also compiled mssql.mib on our SNMP management server. I can snmp poll the device, but it's not returning anything for the SQL OID's.

Does anyone know how to enable SNMP on the server after inistallation?

Sincerely,

-Laura Donovan

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-02-22 : 11:21:46

officially, you need to uninstall/reinstall SQL Server to get the SNMP support to work. there is no option to turn on SNMP after the fact.

Unoficially, you can do the following:

(google for "sql 2000" snmp, found post by Mike Shareski)

1. Under HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\SNMP\Parameters\ExtensionAgents
you'll see some string values there with names starting at zero and
going up to the number of extension agents you have installed (minus
1). All you need to do here is add a string (REG_SZ) using the next
number for the name. The value should be
"SOFTWARE\Microsoft\MSSQLServer\SNMP\CurrentVersion".

2. Under HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer create the
following keys if they do not already exist:
SNMP
SNMP\CurrentVersion

3. Under SNMP\CurrentVersion create a string (REG_EXPANDED_SZ) value
called "Pathname" and set the value to the path to your sqlsnmp.dll
(found in your SQL installation binn folder).

Example:
On one of our systems
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\SNMP\CurrentVersion
we created a REG_EXPANDED_SZ value called "Pathname" and set the value
to "C:\Program Files\Microsoft SQL Server\MSSQL\BINN\sqlsnmp.dll".

Restart SNMP and you're done.

lkd7
Starting Member

4 Posts

Posted - 2005-02-23 : 14:59:20

Updating the registry worked. Thank you so much!

-Laura

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources