I use Windows 2003 R2 x64 and SQL Server 2005 x64.
The problem is: if the Reporting Services Service were doesn't start automatically, despite the set up parameter "Restart Automatically" every 1 minute in the service Recovery property.
So every minute after Service stopped i recieve an error in Event Viewer:
Report Server (MSSQLSERVER) cannot connect to the report server database
However, after starting it manually from Computer Management->Services or
Reporting Services Configuration Tool it starts normally without any error.
I use local system admin account to start Services and to connect to Database. Both parameters are set using RS Configuration Tool.
Will be thankful for any advice.
View Complete Post