sqlagent | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sqlagent

Microsoft SQL Server 2005 – 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
I get the following errors in the sqlagent.out 2007-05-31 10:45:46 – ! [298] SQLServer Error: 15247, User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs)
2007-05-31 10:45:46 – ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object ‘sp_sqlagent_has_server_access’, database ‘msdb’, schema ‘dbo’. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
2007-05-31 10:45:46 – ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object ‘sp_sqlagent_get_startup_info’, database ‘msdb’, schema ‘dbo’. [SQLSTATE 42000]
2007-05-31 10:45:46 – ! [298] SQLServer Error: 229, The INSERT permission was denied on the object ‘syssessions’, database ‘msdb’, schema ‘dbo’. [SQLSTATE 42000]
2007-05-31 10:45:46 – ! [000] Error creating a new session
2007-05-31 10:45:46 – ? [098] SQLServerAgent terminated (normally) I have tried to fixet…
Take a look athttp://msdn2.microsoft.com/en-us/library/ms143504.aspx and alsohttp://sqlserver-qa.net/blogs/tools…r-domain-account-for-sql-server-services.aspx BPA for service account. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
What is the sql agent service account and what level of access it has?
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
]]>