Hi

I have an audit enabled SQL Server DB.Today I tried to read some data.But underlying error occured:

Msg 33201, Level 17, State 1, Line 1
An error occurred in reading from the audit file or file-pattern: 'z:\Audit\*'. The SQL service account may not have Read permission on the files, or the pattern may be returning one or more corrupt files.

Bur I am sure that I have appropriate permission.

• Edited by ArashMasroor Saturday, August 22, 2015 7:32 AM

Can check permission where you can write or create file?

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup  use this

Add your Service account to the  local admin group to the machine where your  Z:\ Drive is.

It should resolve your issue.