?
Solved

Error 1058 Sql server agent won't start

Posted on 2006-06-09
13
Medium Priority
?
3,675 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 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
Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

 
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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

752 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