unable to read server log

Question

unable to read server log

lan2022nguyen

SSC-Addicted

Points: 459
More actions
November 14, 2023 at 12:51 pm

#4327317
```
EXEC sp_readerrorlog 0,1
```
As shown above, Joe1 has the execute permission on the sp_readerrorlog, however getting the error below:
Msg 27219, Level 16, State 1, Procedure sp_readerrorlog, Line 11 [Batch Start Line 0]
Caller does not have permissions to execute the stored procedure.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

You need to be a sysadmin to run that procedure

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-readerrorlog-transact-sql?view=sql-server-ver16#permissions

Permissions
Execute permissions for sp_readerrorlog are restricted to members of the sysadmin fixed server role.

lan2022nguyen SSC-Addicted Points: 459 More actions · Answer 2

Ant-Green wrote:

You need to be a sysadmin to run that procedure
https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-readerrorlog-transact-sql?view=sql-server-ver16#permissions
Permissions Execute permissions for sp_readerrorlog are restricted to members of the sysadmin fixed server role.

We have another instance where the user does not have sa role and able to execute this sp. very odd!

lan2022nguyen SSC-Addicted Points: 459 More actions · Answer 3

the permission needed to execute the sp is view server state. it worked once i added

Ant-Green SSC Guru Points: 113507 More actions · Answer 4

lan2022nguyen wrote:

the permission needed to execute the sp is view server state. it worked once i added

Cool, maybe open a PR with the MSFT docs then to update it to say you need VIEW SERVER STATE and execute on the proc rather than it needing sysadmin.