Solved

My SQL Server Agent will not start.  System Error 1067.

Posted on 2008-06-16
3
4,168 Views
Last Modified: 2012-08-14
I recently inherited a sql server 2000 sp3 installation where the sql server agent will not start.  I recieve the system error 1067.  
0
Comment
Question by:eresser
3 Comments
 
LVL 11

Accepted Solution

by:
dready earned 500 total points
Comment Utility
Did you check the event log?

I found this in another forum, maybe it helps you:

Post1:
The 1067 error is a general error meaning that a service has failed to start.   I would check your event log to see if there is further information there, and also in the SQL log.  Also, try starting the SQL Agent service from the command prompt with the -v switch to display the output to the diag screen.


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_sqlagent_8s32.asp

 
Post2:

 also experienced had a similar error while running SQL2005 SP2. We did receive an error 1067 when manually restarting it via the services snapin.  

Turns out Microsoft dot net framework 2.0 was corrupted.  This was only determined while trying to repair the SQL install and received a prompt regarding dot net 2.0.  So we cancelled the SQL repair and instead repaired the .Net 2.0 installation.  Rebooted and SQL agent started automatically.    Hope this helps.

Regards,
-John
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Suggested Solutions

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

771 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now