Thea Burger's Blog

I would use a Local service account (with minimal domain privileges; but Administrative local) and set the password to never expire.

Check my blog for the full solution straight from the SQL Resource Kit.

Just make sure that the user account you create / use for the SQL service does not have unnessesary rights on the domain and / or server. This account could be attacked to compromise the security of your network and be used as a easy way into your network.

I had a similar one that stumped me for a while. Trying to restore a backup of a database, but the local account that sqlserver was running under didn't have permission to access the directory where the backup file was...

Thea,

Thank you!! I googled and found you site (nice!) and your brilliant answer to my problem - thanks again.

john.e.boy

Google is my friend !
Thanks for the simple and direct solution to this problem.

Thnks, i cleared this problem

Bye
Shabeer

hey, thanks! got your solution off google, like an idiot i removed active directory because i didn't want to go through the hassle of changing the domain name which i had entered wrong during the wizard. now that i was trying to log onto a domain that no longer existed, my sql server needed the new admin password. thanks again!

yup, worked for me too!! Thanks much!

AWESOME JOB DOOD! Google'd and gotcha! You rule! Woot!

That didn't help much

THANK YOU!

Thanks for posting this. No more login problems. I had never even thought to look into the SQL Service properties. :|

Sorry but I was not able to get the exact cause of the problem why the error:"Service did not start due to logon failure" occured.

Please explain me the exact cause.

Thanks
Vartika

I too googled for the same and got the explaination but my query is that why it happened so that while I was installing SQL Server 2000 developer edition on Win. 2000 Professional OS I din't faced any problem like this but during installation on Win. XP Professional edition I faced this.

Please clearify the point.

Thanks
Vartika
vartika.seth@gmail.som

"SQL Server logging on with a domain account and my domain password expired " this is why it happened to me. I don't the problem is the OS that you are running.

I am facing same type of problem. But In my case postmaster service is creating problem. After every restart whenever I try to start this service. It result "The service did not start due to a logon failure" and when I go on to "Log On" tab of service. Every time I found that the passsword of the related user account under which this service is to execute has been changed some how. So every time I correct this password and click APPLY, System confirms with message "[User] has been giving logon as service right". After doing all this service start normally.

But I am not able to find how every time password gets automatically changed. What's going worng ????

Thanks
Anil
kumar.anil@tatainfotech.com

Microsoft SQL Server ODBC Driver Version 03.85.1117

Running connectivity tests...

Attempting connection
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
TESTS FAILED!

this is the error i get i cannot connect to the sql server from a remote computer. my other server works fine but i must have some persmissions problem of some kind.
i tried to look around but everything seems fine.
here is my email just in case. just take off the spaces. thanks
javier @ vndx . com

Anil Kumar wrote:
>>every time I correct this password and click APPLY, System confirms with message "[User] has been giving logon as service right". After doing all this service start normally.<<

This has been happening to us too. Apparently 2k3 server SP1 fixes this. Can anyone confirm?

Thank you so much for this post it was so helpful !!!

Thanks !!! It worked for me.

Attempting connection
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
TESTS FAILED!

this is the error i get i cannot connect to the sql server from a remote computer. my other server works fine but i must have some persmissions problem of some kind.
i tried to look around but everything seems fine.
here is my email just in case. just take off the spaces. thanks gabbyzfriyola @ yahoo . com

found you via Google and you answer solved my problem! Mahalo!

hey..this is simple and straight solution...worked out...
Thanks dude

Thanks! This is a great blog entry! You saved my life :)

> After every restart whenever I try to start this service. It >result "The service did not start due to a logon failure" >and when I go on to "Log On" tab of service. Every time I >found that the passsword of the related user account >under which this service is to execute has been changed >some how. So every time I correct this password and click >APPLY, System confirms with message "[User] has been >giving logon as service right". After doing all this service >start normally.

I have had the same problem running on a Window 2K Advanced server. Possible issue could be with the "Logon as Service", check locally and see what the settings are and if the account you are trying to use has been added. Also you can see what settings are in place "locally" and the actual settings. If GPO are being used in the domain, the settings may become overwritten by the GPO so changes will have to be made to the GPO to include the domain account being used.

Also, like previously stated, that the account being used had "full control" permissions over the data locations for SQL server and also the following registry settings.

Full Control permission applies to the following keys and all child keys:
• For a named instance:
HKEY_LOCAL_MACHINE\Software\Clients\Mail

HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\80

HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\<Instancename>
• For a default instance:
HKEY_LOCAL_MACHINE\Software\Clients\Mail

HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\80

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Cluster

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Providers

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Replication

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Setup

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\SQLServerAgent

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Tracking

Per Microsoft:
http://support.microsoft.com/?id=283811

Hi,

It is working..great....Thanks for google and major partner of this site.

Regards

D.V.S.Varma

Thanks. I had changed the password for the Windows account used to start SQL Server and coming here quickly gave me the right location of where to also change the stored password of the account used to start SQL Server

waw!!Really it was helpful Thanks a lot for nice information
Done the Following:
ControlPannel-->AdminstrativeTools-->Services-->MSSQL Service-Lon on as

Thank the Lord for you and your answer. You just saved me about 15 hours of work!

Thanks so much for this. It saved me a ton of time!

thanks it helped us gr8...

I must agree with all that used google, because my gray was turning white and I deleted and registered a new server group when I should have googled.

Thanks and Keep it up!!

Kudos!!

I'm dying my hair in the morning.

I'll add my name to the list... Google and your site saved me.

Thanks Much !

Thanks it helped us really nice info.....

Worked 100% You are a life saver mate. I was shitting in my pants.

But the odd thing is that i changed the administrator password 5 weeks ago when i when on holidays, that did not affect the sql server from running. However, friday night the server was asking to reboot to apply service packs which i did and then server stopped running. So it appears that the reboot of the sql server is when password change will take effect.

Thanks again

Azam

Thanks!  Google is awesome and so was your easy solution to the problem.

Never thought of properties page. Thanks to Google and this site. I was able to reduce the downtime.

THANKS A TON !!!
So greatfull to get this problem solved. goofle is really great... 3 days of asking and begging guru's and today I solve it in a sec.
thanks for the great posting.

Regards
Gaurav Mathur

He huh what is a domain password and how do I know what I have to enter there ?

Dear sir in case if Domain Password has been forgoton so wht should be then.

This was a great solution!

that was awesome man.. i owe you two hours of my life :)

Thanks much! I was scared when SQL gave this error. Your quick solution worked.

Pingback from  replication wizard does not start sql server