?
Solved

Error 1058 Sql server agent won't start

Posted on 2006-06-09
13
Medium Priority
?
3,727 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
10 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 672 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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 43

Expert Comment

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

Assisted Solution

by:Eugene Z
Eugene Z earned 664 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 664 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 43

Expert Comment

by:Eugene Z
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 43

Expert Comment

by:Eugene Z
ID: 17497967
Ok then - no problems
peace
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

749 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