Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vyelchri
Starting Member
12 Posts |
 Posted - 2009-09-24 : 00:25:03
|
| Hi,I have installed SQL Server 2008 instance in one of my server. SQL Server 2008 service start type is set to "Automatic". Every weekend SQL server database server is scheduled to reboot. After system reboots SQL Server service is not starting up. In the same server SQL Server 2000 and SQL Server 2005 instances are also running. These two services (2000 and 2005) are up after system reboots.How to make the 2008 service is up after system reboots?Thanks,VB |
|
|
scuzymoto
Starting Member
17 Posts |
Posted - 2009-09-24 : 18:45:17
|
| Have you checked the system or app error logs. That my lead you to the issue that is keeping it from opening.Depending on the version of your Server OS you can also set the service to Delay Start. This should cause the service to wait for the non delayed services to start up before attempting to start. There might be some conflict going on that this approach would avoid. On older OS systems there are also registry hacks that allow you to delay your service starts but still have them automatic.I would first research the logs though to see if it is reporting a specific error. |
 |
|
|
|
|
|
SQLServer2008 service not up after system reboots