• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 6 subscribers
  • Views 8051 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

EXECUTE permission was denied on the object 'xp_enumerrorlogs'

JaneDilbert

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!

  • 0

    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.

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 200,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification SolarWinds Lab Link Customer Portal
About THWACK SolarWinds Blog Federal & Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2021 SolarWinds Worldwide, LLC. All Rights Reserved.