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.
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.
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.
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?
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.
change sql server service log on account
Posted - 10/11/2012 : 16:53:46
