[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2383
  • Last Modified:

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!
0
sikyala
Asked:
sikyala
  • 2
1 Solution
 
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now