The report server cannot open a connection to the report server database
Posted on 2011-10-26
I have MS SQL server 2008 on Windows 2008 standard server. It's hosting the reporting service for data warehouse.
Tonight after I applied the Windows patches to the server and reboot the server, then I log into the web portal, I have the following message "...The report server cannot open a connection to the report server database..." shown on the web, then I use MS management studio to open the report MS SQL database, I could not. I have the message "...cannot connect to xxxx..."
Then I check the event log and see the following error
"...Report Server (MSSQLSERVER) cannot connect to the report server database."
"initerrlog: Could not open error log file 'E:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'. Operating system error = 5(Access is denied.)."
The, I tried a couple of methods trying to bring up the server started
1. Use the Windows service to start SQL server, but failed with the same message
2. Use cmd command prompt like below, but still cannot bring up the server
sqlservr.exe -c -s INSTNAME
When I use the above command, I did see something recovering but when running to some point, it stops there. I see the log file
2011-10-26 21:00:19.76 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-10-26 21:00:24.07 spid15s Starting up database 'tempdb'.
2011-10-26 21:00:24.27 spid18s The Service Broker protocol transport is disabled or not configured.
2011-10-26 21:00:24.27 spid18s The Database Mirroring protocol transport is disabled or not configured.
2011-10-26 21:00:24.27 spid18s Service Broker manager has started.
2011-10-26 21:00:24.28 spid7s Recovery is complete. This is an informational message only. No user action is required.
Anyone tell me what is the problem, and how to bring the report database up again.