SQL Server 2000 Connections via WMI

jengstro · Cacti User Joined: 15 Nov 2005 Posts: 156

Hmmm....

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

BSOD2600 · Posted: Mon Dec 12, 2005 7:39 pm Post subject:

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 · Cacti User Joined: 15 Nov 2005 Posts: 156

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 · Posted: Wed Dec 14, 2005 12:42 pm Post subject:

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 · Cacti User Joined: 15 Nov 2005 Posts: 156

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

jengstro · Cacti User Joined: 15 Nov 2005 Posts: 156

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

guarisma · Joined: 22 Sep 2005 Posts: 4 Location: Caracas

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 · Joined: 25 Oct 2007 Posts: 2

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.