Access to Jobs history - bug?

Question

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

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

Michael L John One Orange Chip Points: 27079 More actions · Answer 1

Grant the account that cannot see the logs access to the folder where the logs are stored.

On my local machine, that's C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Log

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

radekg SSC Enthusiast Points: 198 More actions · Answer 2

Hi Michael,

Thanks for such quick response. Could you advise how can I grant SQL's login access to windows folder?

Thanks

Michael L John One Orange Chip Points: 27079 More actions · Answer 3

If the user is connecting using a SQL login, then the service accounts running SQL and SQL Agent need to be granted access.

If they are connecting using Windows Authentication, then that login will need to be granted access to that folder.

I think it may make sense to create a group in AD, add the users to that group, and then grant that group perms.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/