[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Server Error 1069 Service does not start due to logon failure

Posted on 2007-10-13
4
Medium Priority
?
4,744 Views
Last Modified: 2012-06-27
SQL Server Agent will not start on SBS2003 Premium. Error 1069: The service does not start successfully because of a log on failure. I did the research and found MS KB28254  http://support.microsoft.com/kb/282254 This article suggests going into services and putting in the correct password into the SQLAgent.

I tried this. I put in the Administrator password for logging onto the server itself and it makes no difference, the agent will not start.

The other two SQL Services start and run fine.

What am I doing wrong?
0
Comment
Question by:montana4me
  • 2
  • 2
4 Comments
 
LVL 14

Accepted Solution

by:
twoboats earned 2000 total points
ID: 20076732
If you specify local system account, it doesn't need a password.

If you specify another account, e.g. Administrator, you must make sure the administrator password has not expired and the account isn't locked out.
0
 

Author Comment

by:montana4me
ID: 20078908
twoboats, your suggestion worked fine. Thank you.
0
 
LVL 14

Expert Comment

by:twoboats
ID: 20079303
Excellent.
0
 

Author Comment

by:montana4me
ID: 20079565
twoboats, so how can I give you the points you earned? Do you want them? If you do, I will try to fix it. If you don't care that is fine too. I just don't want to short you.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question