Do you ever wonder why Spotlight throws an Access Denied or WMI error while monitoring a Windows server when your user account has all the permissions needed to access that server? You might encounter these errors on the Home page or even at the time of connection. The frustrating part is that even though you can connect via Remote Desktop and Ping the server, you still get those annoying errors! Well, Spotlight actually runs various WMI commands to connect to your server and collect performance metrics for monitoring. These underlying commands are a common cause of these errors. Utilizing some simple commands, you can identify and address the root cause and be on your way to monitoring in no time!
Before we get into the details, let’s clarify the characteristics of these errors:
To find the root cause and rectify these errors, follow these simple steps:
Our Deployment Guide includes a ‘Troubleshooting WMI’ section providing more details about these errors.
Interested in trying Spotlight on SQL Server Enterprise for yourself? Download a free 30-day trial.