How can we help you today? How can we help you today?

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
pholden
0

Comments

2 comments

Sort by
  • Alex B
    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
    Alex B
    0
  • pholden
    Thanks Alex, we have taken the GRANT EXECUTE ON approach.
    pholden
    0

Add comment

Please sign in to leave a comment.