SQL 2005 Reporting Services Error 107 service failed to start could not connect to database
Posted on 2009-02-16
I have a Windows 2003 SP2 server running SQL Server 2005 SP2 and am using Reporting Services. I can't start the RS service now as I receive an error 107 "Report Server (REPORTS) cannot connect to the report server database" in the log. When trying to start via Services the service fails instantly with error 158 and asks me to check dependencies.
The SQL Report Manager Configuration seems to imply everything else is OK but it can't start the service. No recent Windows hotfixes or SQL hotfixes have been applied.
We did have the Confiker virus on the network so I thought account lockouts may have been a reason but it is using Local System and I have tried with a domain admin account and one that is a sysadmin that hasn't been locked out.
Does anyone have any ideas, please?