An error 1069 - (The service did not start due to a logon failure.)

I set up my SQL Server database to authenticate based on the Windows authentication. Unfortunately, I lost the Windows password and didn't realize this before rebooting. I had the password changed. Now when I try to start SQL server I get the following errors:

The service did not start due to a logon failure.

An error 1069 - (The service did not start due to a logon failure.) occurred while performing this service operation on the MSSQLServer service.

Could someone tell me how I could reset the SQL Server password to the new Windows password or tell me how to fix this? Thanks!
sikyalaSenior Database 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.

sikyalaSenior Database AdministratorAuthor Commented:
I tried the following:

1. Click Start, point to Settings, and then click Control Panel.
2. Double-click Administrative Tools, and then double-click Services.
3. Use one of the following steps based on your instance type:• For a default instance of SQL Server, double-click MSSQLServer, and then click the Log On tab.
• For a named instance of SQL Server, double-click MSSQL$YourInstanceName, and then click the Log On tab. Replace YourInstanceName with the actual name of the SQL Server instance.
• For a default instance of SQL Server Agent, double-click SQLAgent, and then click the Log On tab.
• For a named instance of SQL Server Agent, double-click SQLAgent$YourInstanceName, and then click the Log On tab. Replace YourInstanceName with the actual name of the SQL Server instance.
 
4. Type the correct password in the Password and Confirm password textbox, and then click OK.

However, when I enter the new password and click ok I get the following error:

The account name is invalid or does not exist, or the password is invalid for the account specified.
0
sikyalaSenior Database AdministratorAuthor Commented:
I selected local system on the SQLAgent MSSQLServer services and clicked ok Just to test to see if the service would start. I didn't start. So I went back into both services and selected radio button and it repopulated the user account and password. I clicked ok and it prompted me for the correct password. I entered the new Windows password and clicked ok and I got no errors. I did this for both services. Then I right clicked on SQL Server and selected start and it started with no problems. Now I can see my databases etc. Now I am concerned because I do have Microsoft Search and the following instructions apply:

"After changing the SQL Server service account information in Control Panel, you must also change the SQL Server service account in SQL Server Enterprise Manager. This allows the service account information for Microsoft Search service to remain synchronized as well.

Important: Although the Microsoft Search service is always assigned to the local system account, the full-text search engine tracks the SQL Server service account in Windows. Full-text search and failover clustering are not available if Windows password changes are not reset using SQL Server Enterprise Manager."
Using SEM, right-click the Server, click Properties, and then click the Security tab. Under Startup service account, enter the appropriate account and password.

When I enter the windows User name and password I get an error that the username is unknown to windows.
0
imran_fastCommented:
First thing no need to change it in the enterprise manager now.

<<"After changing the SQL Server service account information in Control Panel, you must also change the SQL Server service account in SQL Server Enterprise Manager. This allows the service account information for Microsoft Search service to remain synchronized as well.
>>
inside administrator tools -->servies there is one more service beside MSSQLSERVER and SQLAGENT which is MSSQL SEARCH do the same for it.
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
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

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.