SQL server Agent

Question

Post reply

SQL server Agent

Azzu

Ten Centuries

Points: 1363
More actions
January 18, 2010 at 9:36 pm

#137502

Hi
Will somebody help me with this. What is the name of the component/dll/exe which is responsible for the automatic startup of the Sql Agent. I have configured startup mode of the Sql agent as Automatic but still it does not start automatically i have to start it manually. I was thinking is it possible to repair that particular component?
Thanks in Advance.

Viewing 8 posts - 1 through 7 (of 7 total)

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

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

Full path on my workstation:

"C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\SQLAGENT.EXE" -i MSSQLSERVER"

check the account that you specified to start the service first, sounds like you have a permission issue....

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Azzu Ten Centuries Points: 1363 More actions · Answer 2

Hi

It was working fine till the 8th of this month but from then on it stopped starting automatically. i have the LocalSyatem as the login account. never changed any settings.

Thanks

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 3

i have the LocalSyatem as the login account.

Just as a test, change the account to a domain admin account, and see if the agent starts automatically.

Have you checked your logs for any error or warning messages?

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 4

I would verify that the account can connect to SQL. Check the Agent error log for startup messages, along with the Windows event logs (app + system)

Azzu Ten Centuries Points: 1363 More actions · Answer 5

Hi

I am going through the logs and tresting by changing the account. will let you know once iam through.

Thank you very much for the advice.

Thanks Again.

Azzu Ten Centuries Points: 1363 More actions · Answer 6

Hi

will be doing as suggested by you and will also go through the logs. will keep you updated on this.

Thanks.

Azzu Ten Centuries Points: 1363 More actions · Answer 7

Hi

How to read the .out files generated by sql agent?

I have checked the event log its giving the error as Unable to read local eventlog (reason: The parameter is incorrect).

need to add this

With the login LocalSystem or any other user i am getting this(tested this for 2 logins)

Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]

Thanks.