SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Please Help Me Start SQL Server Agent
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 01/28/2013 :  11:10:27  Show Profile  Reply with Quote
Good morning everyone,

I'm trying to run SSMA and I get a message that says SQL Server Agent needs to be running. So I went to SQL Server Configuration Mangager and tried to start it but I can't because "Start" is greyed out. Can you please help me?

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2043 Posts

Posted - 01/28/2013 :  11:15:58  Show Profile  Visit jackv's Homepage  Reply with Quote
Have you tried from the command window: NET START SQLAGENT$<my_sqlagent_name> ?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3587 Posts

Posted - 01/28/2013 :  11:18:23  Show Profile  Reply with Quote
Do you have SQL Server Agent installed at all? It gets installed as a service, so you can do start -- run -- services.msc and look for "SQL Server Agent" in the services window on the box.
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 01/28/2013 :  11:45:27  Show Profile  Reply with Quote
When I run the net start sqlagent command I get "System error 5 has occured. Access is denied". So I tried re-running the command as administrator and then I this messeage popped up:

C:\Windows\system32>net start "SQL Server Agent (MSSQLSERVER)"
System error 1058 has occurred.

The service cannot be started, either because it is disabled or because it has
no enabled devices associated with it.

When I run services.msc and look for SQL Server Agent I see it and it say "Started" in the status column.

So if it's started then why am I seeing a message in SSMA saying that it needs to be started? I'm so messed up right now.
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3587 Posts

Posted - 01/28/2013 :  13:13:26  Show Profile  Reply with Quote
That is strange - because it should be the same service that shows up in configuration manager, so why it shows as started in services.msc and disabled in configuration manager is something which I don't have an answer to.

Do you have multiple instances of SQL Server/SQL Server Agent installed? They would show up in Services.msc as "SQL Server Agent (MSSQLSERVER)", "SQL Server Agent (SQLEXPRESS)", "SQL Server Agent (A_NAMED_INSTANCE)" etc. If you do, make sure that it is the right service that you have started.
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 01/28/2013 :  14:01:11  Show Profile  Reply with Quote
Ooops it wasn't SQL Server Agent that was started. SQL Server Agent was blank in the status column. So I set it to automatic and tried it with manuel for start up type. Either way when I go to SQL Server Configuration Mangager I get:

The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details.

Any ideas anyone?
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3587 Posts

Posted - 01/28/2013 :  14:09:17  Show Profile  Reply with Quote
What does the event log say? Is SQL Server running? You can also try to start the agent from services.msc by right-clicking. Also you can right-click on it in services.msc and under properties, see the logon account that is set up for this service. If it is not the Local System Account, make sure that the specific account's password has not expired, or try with the system account.
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 01/28/2013 :  14:45:58  Show Profile  Reply with Quote
SQL Server is running. When I try to start SQL Server Agent by right clicking on it and clicking start in services.msc I get: The SQL Server Agent (MSSQLSERVER) service on local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs. I don't know how to check of the password is expired for the account.
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3587 Posts

Posted - 01/28/2013 :  15:47:07  Show Profile  Reply with Quote
What is the account used? Is it the system account or a specific user account?
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 01/28/2013 :  21:08:31  Show Profile  Reply with Quote
It's local system account.
Go to Top of Page

stegib
Starting Member

USA
16 Posts

Posted - 01/29/2013 :  13:24:23  Show Profile  Reply with Quote
Try setting the service to the local admin user logon account. I had the same problem once and used the local admin account and set it to automatic.
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 01/29/2013 :  16:28:18  Show Profile  Reply with Quote
On my vista computer when I boot up It asks me for a password. When I set the computer up on the day that I bought it, I made the user and password the same for ease of remembering it. Any time I reboot the computer I have to enter a password. Is the local admin account the same as the user I described that I created that is using the same value for password and user?
Go to Top of Page

stegib
Starting Member

USA
16 Posts

Posted - 01/30/2013 :  11:56:20  Show Profile  Reply with Quote
Go into the service account of the SQL Agent and set it to the user you log on to Windows with and use the same password, which should have admin rights, then try restarting the service. The user should also be in the Local Admin Group.

Edited by - stegib on 01/30/2013 11:58:12
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 02/04/2013 :  10:41:37  Show Profile  Reply with Quote
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 02/04/2013 :  10:44:21  Show Profile  Reply with Quote
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 02/04/2013 :  10:49:46  Show Profile  Reply with Quote
The first image with the message that mentions network password is the error I get when I use Administrator as the log on. The second message that mentions process terminated is the error I get when I use my log in that I use to boot up my computer with. No matter what I try I can't get this agent started. Is there a way for me outsource this as a project? I have vista which I believe I can't allow someone to rdp into my computer to take a look see. How much would i have to pay someone to help me with this?
Go to Top of Page

stegib
Starting Member

USA
16 Posts

Posted - 02/04/2013 :  12:39:00  Show Profile  Reply with Quote
Is your WMI running?

As far as out sourcing the project you might want to consider calling Microsoft first. There are many ways to remote into your Computer to investigate this but it really comes down to how much are you willing to pay. There is also a liability issue that I do not know if anyone wants to take on. There are many things that can prevent an agent from not starting from improper installation to configuration, service packs, spyware, etc. What are you using SQL for and what version are you using?

Try changing your user access control to 0. It really sounds like a permission access control.

Edited by - stegib on 02/04/2013 12:54:06
Go to Top of Page

jeffw8713
Aged Yak Warrior

USA
794 Posts

Posted - 02/04/2013 :  13:36:28  Show Profile  Reply with Quote
What Edition of SQL Server are you running? If the Edition is Express - then the agent will not work.
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 02/04/2013 :  17:16:59  Show Profile  Reply with Quote
Yes WMI is running.

I'm using Developer 2008 Edition. I thought that developer was like using Enterprise. I found the following query on the internet, ran it and it looks like I'm running Express on my Developer Edition. That's odd.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The results were:
10.50.1617.0 RTM Express Edition with Advanced Services.

Yes I have Express installed side by side with Developer but I'm positive that I'm selecting the Developer Editon as my instance connecting, trouble shooting, and the above query. Why is it appearing as Express? This could be another thread. But for now should I assmume that this Developer Edition won't cut it for the SQL Server Agent?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 02/04/2013 :  18:29:31  Show Profile  Visit tkizer's Homepage  Reply with Quote
You don't have Developer edition of SQL Server. Maybe you do of Visual Studio or something else, but it's Express edition of SQL Server according to that output.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 02/13/2013 :  11:27:53  Show Profile  Reply with Quote
Thanks everyone for the help. I now have the agent started since I'm using SQL Server Standard.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000