January 31, 2012 at 5:09 am
Hi
I have one sql server 2005 STD edition running under Local System.Now I am not able to start the SQLAgent.I found the below error on sqlagent.out file
2012-01-31 12:39:00 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_has_server_access', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
2012-01-31 12:39:00 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_get_startup_info', database 'msdb', schema 'dbo'. [SQLSTATE 42000]
2012-01-31 12:39:00 - ! [298] SQLServer Error: 229, The UPDATE permission was denied on the object 'sysalerts', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (DumpAndCheckServerVersion)
2012-01-31 12:39:00 - ! [298] SQLServer Error: 229, The INSERT permission was denied on the object 'syssessions', database 'msdb', schema 'dbo'. [SQLSTATE 42000]
2012-01-31 12:39:00 - ! [000] Error creating a new session
2012-01-31 12:39:00 - ! [298] SQLServer Error: 15247, User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs)
2012-01-31 12:39:01 - ? [098] SQLServerAgent terminated (normally)
SQL Agent is running under local system
Pls help on this
January 31, 2012 at 5:20 am
Has it recently stopped working or is it a new install?
I always assumed running agent as local system was a bit of a no no.
'Only he who wanders finds new paths'
January 31, 2012 at 5:34 am
Exactly I am not sure.But I Saw that last 3-4 months it was not running.I came new to this project(Account)
January 31, 2012 at 5:37 am
Cheers, just edited my post. To my knowledge I always thought running as local system was a bad idea, I dont know if that would cause the issues though as I would expect it to be part of the BUILTIN\Administrators group. Can you check what server roles the above group is a member of and if it has the necessary rights?
Also, do you have any other SQL instances that you could see what account is being used, there might be a particular account that it should be using?
'Only he who wanders finds new paths'
January 31, 2012 at 8:10 am
I would agree with David.
If the local service is the agent service account and local admins are removed from sysadmin that would cause issues.
What is thhe service account for the engine?
Have the system databases been moved/reconfigured?
Adam Zacks-------------------------------------------Be Nice, Or Leave
January 31, 2012 at 12:08 pm
Hi
Service account is LocalSystem.
I resolved the issue
I added BuiltIN\Administrators on SQL level and given sysadmin privilage.then started sql agent
it started
But one doubt.SQL Server was running without any issue.builtin\admin not required??
January 31, 2012 at 1:07 pm
BUILTIN\ADMIN isnt required as a rule, what account is the SQL Server Service running under?
'Only he who wanders finds new paths'
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply