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 ?
You should be able to go into the SQL Server Configuration Manager and change the password for the SQL Server Services.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!
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.
So be careful using the Services Control Panel to change Service Account passwords for SQLServer Services.
Look for the services and then double click on the SQL Server Service and you can change the password now..