Posts Tagged ‘sp_configure’

The job failed. Unable to determine if the owner (sa) of job has server access.

If you have failing SQL Agent jobs with the following error; The job failed. Unable to determine if the owner (sa) of job has server access. and the following is logged in the SQL Server Log; Message [298] SQLServer Error: 15281, SQL Server blocked access to procedure ‘dbo.sp_sqlagent_has_server_access’ of component ‘Agent XPs’ because this component […]