Solved

Error 1058 Sql server agent won't start

Posted on 2006-06-09
13
3,605 Views
Last Modified: 2012-05-05
When I try to start the SQL server agent it gives me this error: error 1058 the service cannot be started.  The SQL service is running OK with the same credentials.  I set the service to automatic and try to start it but keep gettig the same error.  
0
Comment
Question by:ttelesca
  • 4
  • 2
  • 2
  • +2
13 Comments
 

Author Comment

by:ttelesca
ID: 16870596
Both the main SQL service and the Agent login with administrator account.  
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 168 total points
ID: 16870606
Hi ttelesca,

Check whether the service is enabled ..

Aneesh R!
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 16870616
Start ->run ->services.msc

Double-click on the SQLServerAgent service. Check the Startup Type drop-down menu
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 42

Expert Comment

by:EugeneZ
ID: 16871210
make sure that SQL service has right login 'administrator account' info - UID\PWD
and start service manually..
0
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 166 total points
ID: 16871228
also probably you are starting the Sql agent from your PC' EM- and if on your
server ' Remote Procedure Call service' is disabled  it will give you error:
if it is so - login on the server and start the sqlagent..
0
 
LVL 5

Expert Comment

by:vijay4sql
ID: 16881791
Start ->run ->services.msc ... chek the properties for the sqlagent.. goto logon tab. Chek the hardware profile. Is it disabled... if yes enable it.
thx
VJ
0
 
LVL 5

Assisted Solution

by:vijay4sql
vijay4sql earned 166 total points
ID: 16881812
you can also chek the sqlagent logs to see if we get some more meaning full error message.
thx
VJ
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 17485783
YZlat
< I would appreciate any comments by the experts that would help me in making a recommendation.>
<It is assumed that any participant not responding to this request is no longer interested in its final disposition.>

We are waiting for ttelesca answers to our posts:
some of our posts probably is(are) solution(s) for the question - do not make us beening ignorants

0
 
LVL 35

Expert Comment

by:YZlat
ID: 17495740
EugeneZ, stop being defensive. It's obvious that I was in no way attacking you. I just posted a comment for ttelesca to attract his/her attention to it. No threat to you was posed. And I do not "make anyone being ignorant"
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 17497967
Ok then - no problems
peace
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

813 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

17 Experts available now in Live!

Get 1:1 Help Now