Error: The Enterprise Reporter Server cannot connect to the database. Make sure it has an access to the Enterprise Reporter Database.
说明
When trying to open Configuration Manager you may get the following error:
The Enterprise Reporter Server cannot connect to the database. Make sure it has an access to the Enterprise Reporter Database.
原因
Enterprise Reporter server lost connection with the database.
解决办法
Try the following steps to correct this error:
1- Please go to Windows Services and verify that Quest Enterprise Reporter Server service is running. If not running, please start the service. 2- If the service is running, please restart the service. It might take up to 7 attempts to make it run. 3- Also, confirm that your SQL Server is online and accessible from your Enterprise Reporter server by checking to confirm if the ports are open to access the SQL server from ER server. 4- Ask your DBA to confirm if your Enterprise Reporter database is online and accessible. 5- Run Database Wizard, select existing database option and go through the wizard until is complete. This step will stablish connection between your database and Enterprise Reporter server.
Once you try the above you may open Configuration Manager console or Reporter Manager console successfully.