How do you use cloud databases? Take the survey.

SRP-11129 - Use xp_readerrorlog to read error log - does this require additional permissions

Hi,

We have set up a login for SQL Monitor as per the instructions in the documentation here:
https://documentation.red-gate.com/sm7/getting-started/requirements/permissions

However we are getting the following error:
The EXECUTE permission was denied on the object 'xp_readerrorlog', database 'mssqlsystemresource', schema 'sys'.

I have searched the release notes, documentation and this forum for any instructions on adding additional permissions for this change but I cannot see anything. Are we missing some instructions?

Regards,
Paul
Tagged:

Best Answer

  • Alex BAlex B Posts: 1,131 Diamond 4
    Hi @pholden

    It looks like we've missed updating the permissions there for that - you will either need to
    GRANT EXECUTE ON xp_readerrorlog
    
    Or add the user used to connect to the SQL instance to the securityadmin server role (read about that role here).

    I'll see about updating the documentation as this changed partway through v7.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?

Answers

Sign In or Register to comment.