locked
SQL Server 2005 Reporting Services Not Started RRS feed

  • Question

  • Hi,

    Reporting Services service (sql server 2005 standard edition, sp4) stopped. When I try to start it from windows services there is error:

    "Count not start the SQL Server Reporting Services (SQLServer) service on local computer. Error 1053: The serice did not respond to the start or control request in a timely fashion".

    Any help.

    Thanks

    • Moved by Tom Phillips Tuesday, November 6, 2012 2:45 PM SSRS question (From:SQL Server Database Engine)
    Monday, November 5, 2012 9:57 PM

Answers

  • see -It might help you-

    http://social.technet.microsoft.com/forums/en-US/systemcenter/thread/bd613e3a-3c77-4a85-ad02-c81de5a21287/

    http://msdn.microsoft.com/en-us/library/aa337324%28SQL.90%29.aspx

    http://themossblog.com/articles/event-id-107report-server-windows-service-cannot-connect-to-the-report-server-database/

    http://www.eventid.net/display.asp?eventid=107&eventno=7858&source=Report%20Server&phase=1


    Thanks, Rama Udaya.K "“You only live once, but if you do it right, once is enough. ― Mae West". ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    • Proposed as answer by Fanny Liu Monday, November 12, 2012 1:13 AM
    • Marked as answer by Fanny Liu Tuesday, November 13, 2012 1:11 AM
    Tuesday, November 6, 2012 3:10 AM
  • You need to configure your reporting services.

    http://msdn.microsoft.com/en-us/library/bb839480(v=sql.90).aspx

    http://technet.microsoft.com/en-us/library/ms156305.aspx

    As it seems with error "Report Server (MSSQLSERVER) cannot connect to the report server database." ssrs is facing issue in connecting with report database.


    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

    • Proposed as answer by Fanny Liu Monday, November 12, 2012 1:14 AM
    • Marked as answer by Fanny Liu Tuesday, November 13, 2012 1:11 AM
    Tuesday, November 6, 2012 12:53 PM
  • Hello,

    The error may be caused by many issues, please follow the steps to verify the issue.
        1. All the services for SQL Server Database engine and Reporting Services are in the running state: Click “Start” – “Run” – "Services.msc”, go to Report Server (MSSQLSERVER) and make sure the statues is "started".
        2. Report server database is configured correctly. You can use Reporting Services Configuration Manager to verify the database configuration.
        3. The account used to run the service has permissions on the report server database.

    For more information, please see:
    Configuring a Report Server Database Connection
    Report Server Windows Service (MSSQLServer) 107

    Regards,
    Fanny Liu


    Fanny Liu

    TechNet Community Support

    • Proposed as answer by Fanny Liu Monday, November 12, 2012 1:14 AM
    • Marked as answer by Fanny Liu Tuesday, November 13, 2012 1:11 AM
    Wednesday, November 7, 2012 9:32 AM

All replies

  • Can you please share the error message, on event logs and also from the below location:

    ***\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

    thanks


    Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)

    Monday, November 5, 2012 10:07 PM
  • In event log (application) there is error:

    Event Type: Error
    Event Source: Report Server (MSSQLSERVER)
    Event Category: Management
    Event ID: 107
    Date:  xxxx

    Time: xxxxx
    Computer: xxxx:
    Report Server (MSSQLSERVER) cannot connect to the report server database.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Monday, November 5, 2012 10:25 PM
  • see -It might help you-

    http://social.technet.microsoft.com/forums/en-US/systemcenter/thread/bd613e3a-3c77-4a85-ad02-c81de5a21287/

    http://msdn.microsoft.com/en-us/library/aa337324%28SQL.90%29.aspx

    http://themossblog.com/articles/event-id-107report-server-windows-service-cannot-connect-to-the-report-server-database/

    http://www.eventid.net/display.asp?eventid=107&eventno=7858&source=Report%20Server&phase=1


    Thanks, Rama Udaya.K "“You only live once, but if you do it right, once is enough. ― Mae West". ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    • Proposed as answer by Fanny Liu Monday, November 12, 2012 1:13 AM
    • Marked as answer by Fanny Liu Tuesday, November 13, 2012 1:11 AM
    Tuesday, November 6, 2012 3:10 AM
  • in SQL Server 2005 Reporting Services (SSRS) SP2, both the Report Server Windows service account and the Report Server Web service account require database access.

    u can also refer this along with rest of all this link will help u out in SQL server reporting service troubleshooting

    http://msdn.microsoft.com/en-us/library/ms156468(v=sql.100).aspx 


    Tuesday, November 6, 2012 9:28 AM
  • You need to configure your reporting services.

    http://msdn.microsoft.com/en-us/library/bb839480(v=sql.90).aspx

    http://technet.microsoft.com/en-us/library/ms156305.aspx

    As it seems with error "Report Server (MSSQLSERVER) cannot connect to the report server database." ssrs is facing issue in connecting with report database.


    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

    • Proposed as answer by Fanny Liu Monday, November 12, 2012 1:14 AM
    • Marked as answer by Fanny Liu Tuesday, November 13, 2012 1:11 AM
    Tuesday, November 6, 2012 12:53 PM
  • Hello,

    The error may be caused by many issues, please follow the steps to verify the issue.
        1. All the services for SQL Server Database engine and Reporting Services are in the running state: Click “Start” – “Run” – "Services.msc”, go to Report Server (MSSQLSERVER) and make sure the statues is "started".
        2. Report server database is configured correctly. You can use Reporting Services Configuration Manager to verify the database configuration.
        3. The account used to run the service has permissions on the report server database.

    For more information, please see:
    Configuring a Report Server Database Connection
    Report Server Windows Service (MSSQLServer) 107

    Regards,
    Fanny Liu


    Fanny Liu

    TechNet Community Support

    • Proposed as answer by Fanny Liu Monday, November 12, 2012 1:14 AM
    • Marked as answer by Fanny Liu Tuesday, November 13, 2012 1:11 AM
    Wednesday, November 7, 2012 9:32 AM