Solved

Error 1058 Sql server agent won't start

Posted on 2006-06-09
13
3,582 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
Comment Utility
Both the main SQL service and the Agent login with administrator account.  
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 168 total points
Comment Utility
Hi ttelesca,

Check whether the service is enabled ..

Aneesh R!
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
Comment Utility
Start ->run ->services.msc

Double-click on the SQLServerAgent service. Check the Startup Type drop-down menu
0
 
LVL 42

Expert Comment

by:EugeneZ
Comment Utility
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
Comment Utility
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 5

Expert Comment

by:vijay4sql
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Ok then - no problems
peace
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

763 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

13 Experts available now in Live!

Get 1:1 Help Now