Why the reporting service cannot start automatically?

Posted on 2012-09-09
Last Modified: 2012-09-14
This is using MS SQL 2008 R2 server. For the past few occasions, whenever we restart this server, we found that the MS Reporting service can't be started automatically.We have to start it manually, and then it is started. Any cause why it can't be started? Shall we configure it to start delay?

Thank in advance.
Question by:MezzutOzil
    LVL 17

    Expert Comment

    by:Kent Dyer
    If memory serves, SSRS is an implementation of SharePoint.  You should be able to do quite a bit iwth STSADM.  I would also check your SQL Server to be sure that there are  no errors withn the database too.  The other thought that comes to mind is that there are no errors within the database either.


    LVL 5

    Accepted Solution

    You should have the SQL Server Configuration Manager installed on your server. Open this and locate

    SQL Server Network Configuration

    -> Protocols for "database name"

    In the right hand side of the screen, open properties for TCP/IP

    Once open, go to the IP addresses tab.

    See if you can locate the IP address entry for your VPN address and change 'Enabled' to 'NO'.

    Hopefully, that will allow the DB to startup by itself on a reboot. Let me know
    LVL 5

    Expert Comment

    Maybe also try to set automatic option in

    Administrative Tools-->Services-->SQL Server (SQLEXPRESS)

    got to the properties and set startuptype automatic

    Author Closing Comment


    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Suggested Solutions

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video discusses moving either the default database or any database to a new volume.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now