Solved

Error 1058 Sql server agent won't start

Posted on 2006-06-09
13
3,598 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
 
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

867 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

16 Experts available now in Live!

Get 1:1 Help Now