0

This isn't your typical file system access is denied error. I am pretty perplexed by this issue.

I recently started getting errors from my nightly cube backup job.

File system error:
The following error occurred during a file operation: Access is denied.

I'm not aware of any recent changes to the permissions and they all seem to be intact.

I tried logging into the servers where the backups are located since. I find that even copying a file into the folder in question gives me an "Access is denied" dialog box.

The kicker is that I only get "Access is denied" when I try to copy the .abf file into the folder.

This also happens with the parent folder. I can copy .bak extensions and other files into the folder just fine. The account that is performing the backup has full permissions to the folder as well.

Why am I getting "Access is denied" errors, but only for .abf extensions?

I disabled the antivirus. Still getting access denied.

Paul White
  • 94,921
  • 30
  • 437
  • 687
Geoff Dawdy
  • 1,143
  • 7
  • 23
  • 53

1 Answers1

1

I fixed similar error message on Windows Server 2016 / SQL Server 2017 by granting an access on backup folder to SQL Server Analysis Services (MSSQLSERVER) service account (NT Service\YourAccountName).

Windows Server Services

Peter K
  • 11
  • 1