I want to know the possible causes of this scenario, and how it can be fixed.
1. I am running SQL Monitor 3.3.
2. We recently upgraded two servers from SQL 2008 R2 to SQL 2012.
3. One of the servers is monitoring correctly.
4. The other server, however, has the following issue:
4.1. Under Configuration > Monitored servers, under the server name, it shows "Monitoring Connected"
4.2. Under the (local) section, though, it shows "Connection failed Cannot connect"
Does anyone know why SQL Monitor 3.3 would be able to connect to the server name but not to the (local) instance? I tried running the WMI test at this link
http://www.red-gate.com/MessageBoard/vi ... ion+failed
and it worked when tested from my SQL Monitor server to the server being monitored. But even though I re-enter my credentials or Retry the connection, the situation remains the same - monitoring connected for the server, but connection failed for the (local) section.
Thanks in advance for any help.