EXECUTE permission was denied on the object 'xp_enumerrorlogs'

Hi,

I'm having an issue in one of our DPA where is showing a broken status for many alerts. When I access the status details, the value description reads "The EXECUTE permission was denied on the object 'xp_enumerrorlogs', database 'mssqlsystemresource', schema 'sys'."

BTW, DPA login does have GRANT EXECUTE over xp_enumerrorlogs.

I'm not sure how to start troubleshooting this. Monitored instances are Azure SQL Managed Instance.

Thanks!

Parents
  • I suggest you login to the database using the credentials that DPA does, then try to execute xp_enumerrorlogs and potentially read the error log (EXEC [master].[dbo].[xp_readerrorlog] 0      where 0 is the current file)

    If that is working, then I'd call DPA technical support.

Reply
  • I suggest you login to the database using the credentials that DPA does, then try to execute xp_enumerrorlogs and potentially read the error log (EXEC [master].[dbo].[xp_readerrorlog] 0      where 0 is the current file)

    If that is working, then I'd call DPA technical support.

Children
No Data