SQL Server Performance

WMI Provider for SQL 2000

Discussion in 'General DBA Questions' started by Trev256, Jul 7, 2010.

  1. Trev256 New Member

    1) I have to install the OEM agent and deploy the sql plugin on a sql server 2000. The instructions say 'install and enable windows management instrumentation (wmi) provider of the sql server. Enable support by running the setup.exe file located in the sql server installation cd (<CD drive>/x86/other/wmi). How can I tell if this has already been installed and enabled?
    2) Is WMI provider installed and enabled in SQL Server 2005 by the default intsallation?
    Trev256, Jul 7, 2010
    #2

  2. Luis Martin Moderator

    Check:
    http://blogs.msdn.com/b/sqlexpress/archive/2006/07/29/faq-detecting-sql-server-2005-using-wmi.aspx
    HTH
    Luis Martin, Jul 7, 2010
    #3

  3. satya Moderator

    What version of windows you are using & its service pack?
    satya, Jul 7, 2010
    #4

  4. Trev256 New Member

    hi satya - i'm using windows2003 with sp2 - does the wmi provider for sql server come with this operating system?
    Trev256, Nov 11, 2010
    #5

  5. satya Moderator

    satya, Nov 27, 2010
    #6

Share This Page