none
Unable to start SQL Agent SQL Server 2008 R2

    Question

  • Unable to start SQL Agent SQL Server 2008 R2

    Error logs

    Date,Source,Severity,Message

    10/30/2013 08:19:12,,Information,[098] SQLServerAgent terminated (normally)
    10/30/2013 08:19:12,,Error,[298] SQLServer Error: 15247<c/> User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs)
    10/30/2013 08:19:11,,Error,[000] Error creating a new session
    10/30/2013 08:19:11,,Error,[298] SQLServer Error: 229<c/> The INSERT permission was denied on the object 'syssessions'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000]
    10/30/2013 08:19:11,,Error,[298] SQLServer Error: 229<c/> The EXECUTE permission was denied on the object 'sp_sqlagent_get_startup_info'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000]
    10/30/2013 08:19:11,,Error,[298] SQLServer Error: 229<c/> The EXECUTE permission was denied on the object 'sp_sqlagent_has_server_access'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

    Wednesday, October 30, 2013 5:07 AM

Answers

  • Unable to start SQL Agent SQL Server 2008 R2

    Error logs

    Date,Source,Severity,Message

    10/30/2013 08:19:12,,Information,[098] SQLServerAgent terminated (normally)
    10/30/2013 08:19:12,,Error,[298] SQLServer Error: 15247<c/> User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs)
    10/30/2013 08:19:11,,Error,[000] Error creating a new session
    10/30/2013 08:19:11,,Error,[298] SQLServer Error: 229<c/> The INSERT permission was denied on the object 'syssessions'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000]
    10/30/2013 08:19:11,,Error,[298] SQLServer Error: 229<c/> The EXECUTE permission was denied on the object 'sp_sqlagent_get_startup_info'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000]
    10/30/2013 08:19:11,,Error,[298] SQLServer Error: 229<c/> The EXECUTE permission was denied on the object 'sp_sqlagent_has_server_access'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

    It clearly says, the user does not have the permission.

    Can yuo provide the access to the user as the below link specifies:

    http://msdn.microsoft.com/en-us/library/ms188283.aspx


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Wednesday, October 30, 2013 6:03 AM

All replies

  • HI,

    Please let me know which edition of SQL Server you are using.If it is a EXPRESS Edition,Then you cannot run SQL Server agent service.

    Regards

    Kiran

    Wednesday, October 30, 2013 5:14 AM
  • Hi

    SQL Server 2008R2 enterprise Edition on win Server 2003

    • Edited by Afshin IT.IR Wednesday, October 30, 2013 5:33 AM
    Wednesday, October 30, 2013 5:32 AM
  • As per your errorlog

    I think user does not have permission to start sql agent services.

    Please check once again.


    subu

    Wednesday, October 30, 2013 5:39 AM
  • Hi

    SQL agent is already running

    Wednesday, October 30, 2013 5:59 AM
  • Unable to start SQL Agent SQL Server 2008 R2

    Error logs

    Date,Source,Severity,Message

    10/30/2013 08:19:12,,Information,[098] SQLServerAgent terminated (normally)
    10/30/2013 08:19:12,,Error,[298] SQLServer Error: 15247<c/> User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs)
    10/30/2013 08:19:11,,Error,[000] Error creating a new session
    10/30/2013 08:19:11,,Error,[298] SQLServer Error: 229<c/> The INSERT permission was denied on the object 'syssessions'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000]
    10/30/2013 08:19:11,,Error,[298] SQLServer Error: 229<c/> The EXECUTE permission was denied on the object 'sp_sqlagent_get_startup_info'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000]
    10/30/2013 08:19:11,,Error,[298] SQLServer Error: 229<c/> The EXECUTE permission was denied on the object 'sp_sqlagent_has_server_access'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

    It clearly says, the user does not have the permission.

    Can yuo provide the access to the user as the below link specifies:

    http://msdn.microsoft.com/en-us/library/ms188283.aspx


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Wednesday, October 30, 2013 6:03 AM
  • Hi

    Thank you.

    Wednesday, October 30, 2013 10:43 AM