SRP-11129 - Use xp_readerrorlog to read error log - does this require additional permissions
pholden
Posts: 5 New member
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
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 B
Posts: 1,158 Diamond 4
Hi @pholden
It looks like we've missed updating the permissions there for that - you will either need toGRANT 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
Answers