ASDB Connection Failure

When you try to open a report you receive the following error message, but you know the SQL Service is running and the Arcserve Backup database (ASDB) is online:

"Unable to connect to ASDB Database. Please make sure that SQL SERVICE is running and ASDB database is ONLINE"

Reason

Microsoft SQL server is reusing the cached query plan, but the query plan is poor.

Action

On the central database machine, open SQL Server Management Studio and run the following command: