Auto Start

Question

Post reply

Auto Start

Tara-1044200

SSCoach

Points: 15951
More actions
January 10, 2010 at 7:50 am

#386069

Though my SQL Servers services are set to auto start when i reboot the computer but stilll they are not starting up, i have to manually start the services, what would be the problem.
Thanks

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Dugi SSCoach Points: 17998 More actions · Answer 1

Did you change your password!

If you changed your password, you should go to configure manually to start services with new password!

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Tara-1044200 SSCoach Points: 15951 More actions · Answer 2

Nope, we never change pswd for service accounts which run sql server.

Dugi SSCoach Points: 17998 More actions · Answer 3

What is your error in event viewer!? Did you check it!?

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 4

Are you getting error messages while starting the sql server services manually ?

Dugi SSCoach Points: 17998 More actions · Answer 5

sudhakara (1/10/2010)
Are you getting error messages while starting the sql server services manually ?

As he mentioned above NO, he can starts services manually without any error msgs!

But reasons that services are not started will recorded in the event viewer.

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

moorthy.jy SSCommitted Points: 1753 More actions · Answer 6

Just curios: Is SQL agent startup is manual or auto start?

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 7

Tara, could you please answer Dugi's question. There must be something in the event logs.

My blog

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 8

Ignacio A. Salom Rangel (1/10/2010)
Tara, could you please answer Dugi's question. There must be something in the event logs.

I agree. And I would check both the SQL Server AND Windows logs.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service