- Confirm the Enterprise Reporter Server Service is running
- Confirm the account is a member of at least the Reporter_Reporting_Operators group in AD
- Try logging in as the service account and test to see if you get the same error
If you still get the error after trying to use the service account, and the ER Server service is running, try running the ResetDatabaseSecruity.sql script:
- Open SQL Server Management Studio and connect to the SQL server where the ER database is hosted
- Create a backup of the ER database
- Copy the ResetDatabaseSecurity.sql file to the SQL server. This file is located on the ER server under:
<installDrive>\Program Files\Quest\Enterprise Reporter\Server\Database - Run the ResetDatabaseSecurity.sql script against the ER database using SQL Server Management Studio
If the error still occurs, try deleting the ER database and reinstall ER, ensuring the account you run the Database Wizard as has SysAdmin rights to the SQL server.