Configure WMI to Show Server Status in SQL Server Tools

• Harold Buckner

  SSCarpal Tunnel

  Points: 4175

  More actions

  December 14, 2007 at 9:08 am

  #182135

  I have set up several window servers 2003 sp1 and 2 to show the server status in SQL Server management studio for non-administrators but this one is killing me. This is the first cluster I've setup and I want to set it up to show the server status in a remote SQL Management Studio being used by a non-administrator and I just can't make this happen. I have done everything I normally do according to http://msdn2.microsoft.com/en-us/library/ms188690.aspx and several other articals.

  I've set security in the WMI control, DCOM and set the acl security on the services themselves in group policy. I think it has something to do with the Cluster. Since the user is not an administrator they can not administrate the resources in the cluster. I've even tried to give the account admin rights in the cluster administrator but that did not work either.

  Does anyone think this is possible or have a document to properly set the security to allow non admins to stop and start show status for the management studio.

  Thanks in advance.

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  December 14, 2007 at 11:00 am

  #760382

  This link might help - scroll down the page approx 1/3 to the section titled "WMI (Windows Management Interface) Management".

  http://book.itzero.com/read/microsoft/Prentice.Hall.PTR.Windows.Server.2003.on.HP.ProLiant.Servers.Oct.2004.eBook-DDU_html/0131467581/ch13lev1sec3.html

  Tommy

  Follow @sqlscribe