error 1067-sql server agent

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Agent » error 1067-sql server agent

error 1067-sql server agent

Rate Topic

Display Mode

Topic Options

Author

Message

Manish Makwana

Posted Friday, June 25, 2004 5:40 PM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, November 29, 2011 5:21 AM
Points: 433, Visits: 151

While starting sql server agent service on my server it is giving following error:

error 1067 :the process terminated unexpectedly

I have restarted the server by making the service autostart.

Then i tried to change the user and gave the user "log on as a service" right and restarted the server but it didn't worked.

Thanks & Regards,
Manish

Post #123137

Site Owners

Posted Monday, June 28, 2004 8:00 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

Post #123308

A.J. Wilbur

Posted Wednesday, June 30, 2004 3:36 PM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:41 PM
Points: 944, Visits: 393

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

A.J.
DBA with an attitude

Post #124027

Manish Makwana

Posted Thursday, July 01, 2004 11:17 PM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, November 29, 2011 5:21 AM
Points: 433, Visits: 151

Thanks for the help.

I tried starting service through command prompt with follwing command.

net start SQLServerAgent -v

The output displayed was the same error.
-----------------------------------------------------------
The SQLSERVERAGENT service is starting.
The SQLSERVERAGENT service could not be started.

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

---------------------------------------------------------------

I have checked eventlog it shows -
The SQLSERVERAGENT service terminated unexpectedly. It has done this 11 time(s). The following corrective action will be taken in 0 milliseconds: No action.

And sqlerror log has logged nothing.

pls help further

Regrads,
Manish

Post #124383

John Cullinane

Posted Wednesday, February 20, 2008 12:40 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2008 12:36 PM
Points: 1, Visits: 0

I 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

Post #458175

SQL ORACLE

Posted Wednesday, February 20, 2008 9:04 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, December 02, 2011 4:32 PM
Points: 1,438, Visits: 1,207

Error 1067 is a general error. Check your SQL logs and event logs and see what you find.
This error may indicate an error in registry also.

Post #458340

stasi48

Posted Thursday, April 30, 2009 2:40 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, August 15, 2009 10:04 AM
Points: 1, Visits: 6

John Cullinane (2/20/2008)

Similar scenario: SQL2005SP2 .NET1 , .NET2, .NET3 instaled.
As in the case above it was dot NET2 that broke. I have executed repair from [Add or Remove Programs] and after a restart all was OK!

Thanks a lot! Smile

Post #708060

bugmenot-573553

Posted Saturday, May 23, 2009 8:32 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, September 28, 2010 4:16 AM
Points: 71, Visits: 5,439

Thank you so much.
It's great topic!!!! BigGrin

Post #722577

Declan Corcoran

Posted Sunday, July 18, 2010 11:56 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 24, 2012 4:32 AM
Points: 8, Visits: 36

Im my case repaired .NET 3.5 worked without restart. Thanks you!!

Post #954604

ezbutton

Posted Tuesday, March 01, 2011 3:42 PM

Old Hand

Group: General Forum Members
Last Login: Wednesday, April 20, 2011 1:11 PM
Points: 338, Visits: 39

For those of you who have arrived here after attempting to install from a mounted .iso image, try this:

- Uninstall any features that failed during installation or whose related service couldn't start

- Use WinRAR to extract the .iso to a local folder. WinZip doesn't always unpack .iso images reliably.

- Run the installer from the local folder instead of the .iso

I had the same problem trying to install SQL 2008 R2 on a Windows 7 Ultimate VM, and these steps worked for me. I use separate local accounts for each service.

Cheers,
Donny

Post #1071646

« Prev Topic | Next Topic »

Permissions