Versions Compared

Old Version 6

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 7

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

REASON

IDERA SQL Inventory Manager connects frequently to managed SQL Server instances to ensure they are available and responsive. If the SQL instance becomes unreachable for any reason, an alert will be raised to let operators know that an availability problem may have arisen.

RESOLUTION

First, attempt to connect to the SQL Server instance by means other than SQL Inventory Manager. If the connection fails, take note of any error message, which may in some cases explain what the issue is. If the message is not helpful or if the connection simply times out, verify whether the host Windows 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. When 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.

...