Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Why the reporting service cannot start automatically?

Posted on 2012-09-09
Medium Priority
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
  • 2
LVL 17

Expert Comment

by:Kent Dyer
ID: 38381713
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.



Accepted Solution

elevationkevin earned 1000 total points
ID: 38381714
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

Expert Comment

ID: 38381715
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

ID: 38397957

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Backup & Restore 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.
Loops Section Overview
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

564 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