Sql server 2008 problem

I have sql server 2008 running on a windows server 2003 machine. Recently I received the following after rebooting the machine: "The MSSQLSERVER service was unable to log on as .\SQL_Services with the currently configured password due to  the following error: Logon Failure: the specified account password has expired.'  I cannot right click on the service and change the password. How do I change the password after it has expired ?
LarryPrattSystem AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DBAduck - Ben MillerPrincipal ConsultantCommented:
You should change the password in SQL Server Configuration manager in Programs \ SQL Server 2008\Configuration Tools\SQLServer Configuration Manager.

Look for the services and then double click on the SQL Server Service and you can change the password now..
0
computerstreberCommented:
You should be able to go into the SQL Server Configuration Manager and change the password for the SQL Server Services.
0
cyberkiwiCommented:
You have configured the SQL Server service to run as a specific local user account called "SQL_Services".  And it's password has expired.
You can right click on My Computer, click on Manage
Then expand the tree to System Tools / Local Users and Groups / Users.
Right-click on the user SQL_Services, and "Set Password"

Expand the tree again to Services and Applications / Services
Find the service named SQL Server (MSSQLSERVER), double-click
Go to Logon tab and change the password (both boxes)
Click OK

Done
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LarryPrattSystem AdministratorAuthor Commented:
Thank you. The SQL services came up. The only one that didn't is SQL Server VSS Writer. It shouldn't interfere with anything, but I do need to get that figured out next. Thanks again!
0
DBAduck - Ben MillerPrincipal ConsultantCommented:
I suggested the SQL Configuration Manager because it is recommneded that you change the SQL Server Services passwords using SQL Configuration manager because it has the right processes inside to maintain any Encrypted keys, etc. so that the security chain is not broken.

So be careful using the Services Control Panel to change Service Account passwords for SQLServer Services.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.