Page History
REASON
SQL Inventory Manager will attempt to verify the availability of a SQL Server by contacting its host Windows server. If the server becomes unreachable for any reason, an alert will be raised to let operators know that an availability problem may have arisen.
RESOLUTION
Verify whether the server is available through a ping test or by attempting to connect via remote desktop. If the server is not responsive, it may be necessary to troubleshoot further to determine whether it is a network issue or whether the server is itself offline or unresponsive. Once the server is verified to be back online and reachable, check to make sure that the SQL Server services are started for any and all hosted SQL Server instances.
If the server was offline and the downtime sudden or unexpected, SQL Server may need to run recovery for its hosted databases before the instance will be fully available again. Recovery is the process by which completed database transactions are recovered and incomplete transactions are rolled back, bringing the system back into a consistent state. This may complete quickly or it could take an extended period of time, so pay close attention to the status of the databases on this instance until they are all accessible again.
If the server is online and this message appears to be in error, it could be that network or security issues are preventing SQL Inventory Manager from making a connection. Ensure that SQL Inventory Manager is connecting to the SQL Server with credentials that have the right to make WMI calls to the target server.
In order to use WMI, the user account under which the Collection Service runs must have administrator permissions on the remote server. The most frequently encountered problems with WMI relate to RPC traffic failing to get through to the remote computer. Another issue involves DCOM/WMI permissions.
The following links provide additional information about how to troubleshoot WMI connectivity issues:
Using WbemTest (Windows Management Instrumentation Tester)
...