Jane's Technical Stuff
Archives
May 2002March 2003
May 2003
July 2003
August 2003
June 2005
July 2005
August 2005
December 2005
January 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
July 2008
August 2008
September 2008
October 2008
Wednesday, June 20, 2007
Can't logon to SQL Server 2000/2005 after password change
We have a strict password change policy here, and having changed my password yesterday I could no longer start either of my two local instances of SQL Server.
On an attempted start I got an error message:
"The MSSQLSERVER service was unable to log on as with the currently configured password due to the following error:
Logon failure: unknown user name or bad password." error.
To resolve this I headed to Control Panel -> Services and selected MSSQLSERVER. I right clicked, selected Properties and opened the Log On tab. I updated the password and confirm password and then skipped back onto the General tab and started the service. It worked :-). I did the same with SQL Server (SQL2005), also successfully.
On an attempted start I got an error message:
"The MSSQLSERVER service was unable to log on as
Logon failure: unknown user name or bad password." error.
To resolve this I headed to Control Panel -> Services and selected MSSQLSERVER. I right clicked, selected Properties and opened the Log On tab. I updated the password and confirm password and then skipped back onto the General tab and started the service. It worked :-). I did the same with SQL Server (SQL2005), also successfully.
Labels: SQLServer, SQLServer2005
// posted by Jane @ 10:05 AM 
Comments:
