SQL Server 2000 Connections via WMI

jengstro · Post by **jengstro** » Mon Dec 12, 2005 5:53 pm

Hmmm....

Any others able to get this working and can offer some advice?

BSOD2600 · Post by **BSOD2600** » Mon Dec 12, 2005 7:39 pm

1 Start | Run: gpedit.msc
2 Navigate to: Computer Configuration | Administrative Templates | Network | Network Connections | Windows Firewall
3 Enable the following:
Allow remote administration exception
Allow local port exceptions

Just remembered I had to do that too to get WMI working for mine (updated the FAQ too). WMI work for you now?

jengstro · Post by **jengstro** » Wed Dec 14, 2005 10:59 am

I don't have a "Windows Firewall" selection under "Network Connections". Here is what is listed...

Prohibit use of Internet Connection Sharing of your DNS domain network
Prohibit use of Internet Connection Firewall on your DNS domain network
Prohibit installation and configuration of Network Bridge on your DNS domain network
IEEE 802.1x Certificate Authority for Machine Authentication

These all have a State of "Not configured".

BSOD2600 · Post by **BSOD2600** » Wed Dec 14, 2005 12:42 pm

Only Windows XP SP2 and 2003 have this firewall option. If you don't have the options, then you shouldn't have to worry about it.

jengstro · Post by **jengstro** » Wed Dec 14, 2005 12:44 pm

Well darn... I was hoping this was the fix. Thanks for the info either way.

jengstro · Post by **jengstro** » Tue Jan 10, 2006 6:40 pm

Any other ideas by chance? I am still having a bear of a time getting any SQL data...

guarisma · Post by **guarisma** » Tue Jan 17, 2006 4:25 pm

I cannot find Win32_PerfRawData_MSSQLSERVER_* in my Classes, I try resync wmi, and nothing....

I have a Server wich has it , the difference between both servers is that one has the Original SQL Server Instance (exp. SERVER1) and the other doesn't, at installation time it was created a instance with a name like SERVER2\DEV instead of only SERVER2

What I'm I missing??

wendell.gt · Post by **wendell.gt** » Thu Oct 25, 2007 5:54 am

Win2000 with SQL2000 and I wanted to know the procedure for implementing the class "Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics"
I do not know where or how to download and install.

Sorry for the poor English.

Thanks.

cahonis · Post by **cahonis** » Thu Dec 10, 2009 6:45 am

I'm getting ERROR: Empty Result when this is run by the poller (using an account not system).
If I run it from a cmd window it completes successfully.

I've used the full paths in the Data Input Method:
C:\Perl\Bin\perl.exe D:/cacti/scripts/w32_sql_query_connections.pl <hostname> get UserConnections,LoginsPersec,LogoutsPersec

what have I not configureed correctly?

Cacti

SQL Server 2000 Connections via WMI

Implement the class

Who is online