Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

That's the first time I use SSRS so my apologies if I'm asking something stupid.

I have a SQL Server 2008 R2 already installed with SSRS. When I try to start the SQL Server Reporting Service I receive this error:

System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed. at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout) at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)

Can someone help me with this issue? Which tests cna I do in order to debug/fix it? Thanks in advance!

share|improve this question

closed as off-topic by Paul White, RolandoMySQLDBA, Max Vernon, Michael - sqlbot, Kin Feb 6 at 20:17

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Paul White, RolandoMySQLDBA, Max Vernon, Michael - sqlbot, Kin
If this question can be reworded to fit the rules in the help center, please edit the question.

    
Have you checked your event log to see if there is any additional information? –  Kenneth Fisher Jan 31 at 17:55
add comment

1 Answer 1

up vote 2 down vote accepted

If you open sql configuration manager, right click the Reporting Services service, go to properties, then advanced you should see an option to turn on error reporting.

It will also have the dump directory location. Check the latest log in there and it should tell you why it couldnt start.

share|improve this answer
    
The Errors I can see in the log:ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException:, Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. –  Dalek Jan 31 at 17:59
    
Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server –  Dalek Jan 31 at 18:00
    
Hmm, I'd make sure your using a good service account at that point. Also verify you can connect to the instance with SSMS –  Nabil Becker Jan 31 at 23:49
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.