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.

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

It should resolve your issue.

Well this has lot of security issue. There is no need to add service account to local admin this defeats the purpose of creating service account with limited privileges.  If that is case one would always use local System.

Arash,

What you can do is grant service account read and write permission on folder and subfolders where audit file is present. Dont add service accoutn to local admin, security wise this is not a good practice