No SQL Monitor but WMI are OK

jhosen · March 20, 2019 11:05AM

If I add the server to monitor using the administrator user, the operation is correct.
But when adding it with other credentials (not administrator) the connection is correct but the SQL Server server does not appear. It does not monitor the SQL Server metrics, however the WMI does. The user is sysadmin in SQL Server.

And it does not appear in overviews.

The SQL Server instance is not displayed:

Image: https://us.v-cdn.net/6029854/uploads/editor/3j/qemvxadqnaq5.png

If add server as administrator:

Image: https://us.v-cdn.net/6029854/uploads/editor/q3/m6w6cso6g3p1.png

Now I edit the credentials and use the non-administrator user:

Image: https://us.v-cdn.net/6029854/uploads/editor/nn/eqmvit2xbj7h.png

The problem I have with a server where we do not have access as administrator. We do not know what to do anymore.

Russell D · March 21, 2019 11:33AM

Looking at this screenshot.. it specifically fails until you add it as an administrator, then edit the credentials back to a non-administrator?

No SQL Monitor but WMI are OK

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk