September 23, 2009 at 10:19 pm
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?
September 23, 2009 at 10:44 pm
September 24, 2009 at 2:04 am
vyelchri (9/23/2009)
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?
Did you make any changes to the service account for sql server. sometimes if you make any changes using the services.msc, it can stop it starting. all changes need to be done via the sql tools. other than that I would do as suggested and see what is in the windows logs as service starts/stops are recorded.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply