Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 change sql server service log on account
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

230 Posts

Posted - 10/11/2012 :  16:53:46  Show Profile  Reply with Quote

Since computer restarted, sql server service could not start and was just showing "starting" but could not start.

After trying many things, even computer reboot many times, finally I went to sql server properties and changed logon built-in account to computer administrator account with password. It works.

I wonder what the cause of the problem and which user is built-in account and if my change will cause any problem in the future.

Most Valuable Yak

15732 Posts

Posted - 10/11/2012 :  16:59:26  Show Profile  Visit robvolk's Homepage  Reply with Quote
Is the original account still active? Was its password changed since the service was last started?

Be sure to use a dedicated account rather than a user account for running the service. While you should change the password regular, it should be set to never expire.
Go to Top of Page

Posting Yak Master

230 Posts

Posted - 10/12/2012 :  02:36:06  Show Profile  Reply with Quote
Thanks robvolk.

Initially while installing sql server 2005, I just managed to install using default options.
So i don't know which account is built-in for sql server 2005 and I wonder how I can check it.

As far as I know I have never changed any windows login passwords.

Edited by - learning_grsql on 10/12/2012 02:36:53
Go to Top of Page

Posting Yak Master

230 Posts

Posted - 10/14/2012 :  02:07:16  Show Profile  Reply with Quote
After restart again today I got the same problem. Today I had to change back the account to built-in account to make it work. The built-in account is "Local system" which I just found in "sql configuration manager:"

So it seems this problem occurs every time computer reboots. Is there any permanent solution for this?
Go to Top of Page

Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 10/14/2012 :  12:10:10  Show Profile  Visit jackv's Homepage  Reply with Quote
have you since rebooted and it happens again?

Jack Vamvas
Go to Top of Page

Posting Yak Master

230 Posts

Posted - 10/14/2012 :  12:59:20  Show Profile  Reply with Quote
yes it happens again and again but not on every reboot but most of the times(even today it happened). But I know the solution just play with user account and get back to previous account, it would work. It would be better if I'm able to find exact problem and sort out permanently though.

Edited by - learning_grsql on 10/14/2012 13:02:38
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000