HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Which permissions are required to view Windows Event Logs in SSMS?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
permissionsssmslogsareviewwindowswhichrequiredevent

Problem

I'm trying to figure out which permissions are required to be able to view the Windows Event Logs via SSMS.

The SSMS Log File Viewer, where you typically view the SQL Server Errorlog, also has the ability to show the Windows Event Logs via a "Windows NT" checkbox & subtree (pictured below). Being a SQL Server sysadmin and Windows Administrator this shows up just fine for me.

  • Is there a way to give other users the ability to view the Windows Event Logs within SSMS, without giving them SQL SysAdmin and Windows Admin level permissions?



I've tried the Event Log Readers local security group in Windows, but that doesn't appear to work.

Solution

The two groups highlighted in the attached image (Administrators and Event Log Readers) will allow a user, or a member of a group, who is given access to either of these two local groups the ability to view the windows event log. Of course, as long as they are logged on via an AD account.

Context

StackExchange Database Administrators Q#148583, answer score: 2

Revisions (0)

No revisions yet.