1) How do I check the WMI (windows management instrumentation) provider is installed and enabled on a sql server 2000 box? 2) Is this provide automatically installed for SQL server 2005 and 2008? Thanks!
See if these links help: [quote user="Trev256"] 1) How do I check the WMI (windows management instrumentation) provider is installed and enabled on a sql server 2000 box? [/quote] http://www.databasejournal.com/features/mssql/article.php/1503181/Automating-SQL-Server-Management-with-WMI-Part-1.htm http://msdn.microsoft.com/en-us/library/ms180606%28SQL.90%29.aspx
Hi Frank these links state if u install and enable wmi provider for sql server 2000 then it creates root/MicrosoftSQLServer namespace and populates with definitions of all SQL Server classes. The link does not explain how to check if this exists. Do you know how i can check the WMI provider has been installed and enabled???? also, this suggests SQL server 2005 automatically installs and enables the wmi provider but it does not explicitly state this. Can you confirm 2005 does install and enable the wmi provider???? Thanks
From Control panel go to Services and make sure following are running: -. SQL Server (MSSQLServer) -. Windows Management Instrumentation If you have Windows Management Instrumentation Driver Extension, try to start it as well. Now, open a command prompt and go to folder Crogram FilesMicrosoft SQL Server90Shared and execute: mofcomp "Crogram FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof
