WMI Connectivity SQL 2000 Cluster

Sep 11, 2014 at 6:53 AM

Just wanted to start by saying thank you for providing such a great tool. I have already used it successfully on a couple of environments and it has saved me a lot of time.

I've just started working for a new client and I am trying to use the tool to document a SQL 2000 clustered instance and I am hitting a road block during the WMI connectivity test.

The log file is reporting;

WMI response from XXXXX: False

I've tried using the differing logging modes and I haven't really got any clearer of an idea why this is happening. I thought it maybe that the WMI service isn't installed for the SQL 2000 instance but not being a WMI guru I'm not sure how to verify this.

Any help you can provide would be greatfully received.

Thanks again

Nov 11, 2014 at 6:02 PM
You can test if WMI is working and you've got the necessary rights to access it by simply dropping to a PowerShell console and running the following (make sure to change the computername parameter to match the SQL 2000 computer name):
gwmi win32_operatingsystem -computername 'SQL2000ComputerName'
If you get data back then you know WMI is working; if you get an error then the reason why you can't connect should be in the error message.