SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


error 1067-sql server agent


error 1067-sql server agent

Author
Message
Manish Makwana
Manish Makwana
SSChasing Mays
SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)

Group: General Forum Members
Points: 629 Visits: 168
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
Site Owners
Site Owners
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: Administrators
Points: 61039 Visits: 364
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!
Adam Wilbur
Adam Wilbur
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 6024 Visits: 591

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
Manish Makwana
Manish Makwana
SSChasing Mays
SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)

Group: General Forum Members
Points: 629 Visits: 168
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
John Cullinane
John Cullinane
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 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
SQL ORACLE
SQL ORACLE
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25017 Visits: 1314
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.
stasi48
stasi48
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 10
John Cullinane (2/20/2008)
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



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! :-)
bugmenot-573553
bugmenot-573553
SSC Veteran
SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)

Group: General Forum Members
Points: 201 Visits: 5439
Thank you so much.
It's great topic!!!!:-D
Declan Corcoran
Declan Corcoran
SSC-Enthusiastic
SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)

Group: General Forum Members
Points: 108 Visits: 62
Im my case repaired .NET 3.5 worked without restart. Thanks you!!
ezbutton
ezbutton
SSC-Addicted
SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)

Group: General Forum Members
Points: 476 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search