Service logon password won't save

[MD5150]

The default network account/password fails to start the service at logon.

I don't know what the default password is, or the history of how this problem started, but when I enter our current network admin password, it is granted rights and the service starts. But on the next reboot, the logon settings revert back to whatever the original password was and fails to start the service.

Any idea of what I need to do to make this logon password stick?

Thanks,

Mike

 

[mrdenny]

It's not the password. Sounds like you have a domain policy which is removing the logon as a service right from the accont that the SQL Server is running under.

Edit your policies which set the login as a service rights and add the account to the policy.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[MD5150]

Thanks Denny. I'll check it out. I've been told that the problem started happening after one of our engineers had removed some components of SBS. But I'll check the domain policy, thanks.

Mike