Monitor Service Account issue when group added to local admin.

Answers

• Options

  jrguay Posts: 11 Bronze 2

  May 23, 2019 7:30PM

  Hi @Reggie.

  I'm not sure as I have not seen this particular scenario personally, but have dealt with some WMI issues before. My guess is that the DC's are trying to connect to the monitored server with WMI and they can't. Maybe you can check whether the WMI ports are open and accepting traffic. You can find more information about that here: https://documentation.red-gate.com/sm9/configuring-sql-monitor/adding-servers-to-monitor/adding-servers-on-a-different-network-from-your-base-monitor
  

  
  

  0 · Share on Twitter
• Options

  Reggie Posts: 6 New member

  May 23, 2019 7:41PM edited May 23, 2019 7:50PM

  There can't be an issue with WMI as it worked just fine when the account was added directly to the admin group.  It's only now that the account was added to a group and then in turn added to the admin group that things stopped working.
  
  EDIT: Also the monitor and monitored servers are all on the same network.

  0 · Share on Twitter
• Options

  jrguay Posts: 11 Bronze 2

  May 23, 2019 7:51PM

  Ok. I misunderstood then. So, if I remember correctly, Windows permissions are restrictive, meaning, if you have a group that has permissions, then add the account, the account will have the permissions. If the account is added to a group, and this group does not have permissions, even if the group is added to a group that does, the account will not have permissions, because the account belongs to a group that doesn't have them.
  

  I think you need to check permissions on both groups, and make sure both groups do have the permissions to access the server.
  

  1 · Share on Twitter