sql server agent 2008 service is not starting

Question

Post reply

sql server agent 2008 service is not starting

akulaanr

SSC Rookie

Points: 47
More actions
January 1, 2011 at 5:13 pm

#157372

hi
Please help me for taking automatic backups in sql 2008, previsouly i am using sql 2005 in that i am using maintainance plans for taking automatic backup. In this sql 2008 i am not able to take automatic backups . I am not able to start sql server agent in 2008.
Please mail me on akulaanr@gmail.com

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

How are you trying to start the SQL Server Agent service?

Do you receive any error messages?

p.s.: I wouldn't post your e-mailaddress on forums, unless you are interested in being contacted by a spambot

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Jim Johnston SSC Enthusiast Points: 178 More actions · Answer 2

Is SQL Agent enabled in SSCM?

Also, run sp_configure and check the status of 'Agent XPs',

some security scans set this value to '0' but to run SQL Agent you need it enabled

To enable it use the following

Use master

GO

exec sp_configure 'show advanced options', 1

reconfigure

exec sp_configure 'Agent XPs', '1'

reconfigure

GO

akulaanr SSC Rookie Points: 47 More actions · Answer 3

Thanks for reply

OPERATION SYSTEM 2008 SERVER

I am starting from services.msc and i am getting the error message 'THE SQL SERVER AGENT(MSSQLSERVER0 SERVICE ON LOCAL COMPUTER STARTED AND THEN STOPPED. SOME SERVICES STOP AUTOMATICALLY IF THEY ARE NOT IN USE BY OTHER SERVICES OR PROGRAMS.

While installation i had the log on account as NETWORK SERVICE and after i changed to local system. I searched some events on this issue they posted it should be logined thru NTAUTHORITY/NETWORK SERVICE. When i am trying to log on account thru NETWORK SERVICE it is asking for passord. I had tried for sysadmin but it is not working.

akulaanr SSC Rookie Points: 47 More actions · Answer 4

Thanks for the reply

While enabling in sscm the error is getting 'Access is denied. [0x80070005]'

I got below 2 points when i am searching

http://support.microsoft.com/kb/2397020

I tried the first one but it is not working and second one i ddn't get that point

1)In SSCM, change the instance of SQL Server to a different account. For example, click Built-in account, and then select the Local System account.

2)Change the instance of SQL Server back to the original account by using the new password of the Windows account.

Jim Johnston SSC Enthusiast Points: 178 More actions · Answer 5

The second point is in reference to a service account that has expired. Many organizations use a service account to manage their SQL Server services for security purposes and normally it is set to expire at intervals. Imagine managing 800 SQL Servers and you must reset their password every 90 days. For SQL Server 2005 and above you should always use SSCM instead of services.msc for authentication changes and properties. Also if you must use the default services, always perfer Network Services since it is more secure than using the Local System account. The local system account is like the old Built-In Administrator account which gives sysadmin permissions to all administrators on the box.

You should have installed SQL Server using an administrative account. It sounds like you do not have the correct authority to manage the SQL accounts.