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

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

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

I recently inherited a sql server 2000 sp3 installation where the sql server agent will not start.  I recieve the system error 1067.  
0
eresser
Asked:
eresser
1 Solution
 
dreadyCommented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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