DBCreate backup access denied using Windows Server 2008 R2 Standard & Microsoft SQL 2008 R2

Issue

DBCreate backup access denied using Windows Server 2008 R2 Standard & Microsoft SQL 2008 R2

Product Line

TAC I/NET

Environment

I/NET loaded on Windows Server 2008 R2 Standard & Microsoft SQL 2008 R2

Cause

'Cannot open backup device ' C:\Users\Administrator\Desktop\20120919'. Operating System Error 5( Access is denied). [Microsoft][ODBC SQL Server Driver] [SQL Server] BACKUP DATABASE is terminating abnormally'

Resolution

The problem is the rights to perform this function. Are you using a Network Administrator account or Administrator for the local machine? Although using a network administrator account you cannot open backup to either the local machine 'C' drive or a network share. You should be able to backup to a thumb drive. The problem is based upon a local policy of not allowing users to see the 'C' drive. Under local disk properties - security tab, Users do not have permissions to modify or write to the 'C' drive. Windows UAC may over ride the administrator permissions. Check your permissions and make sure you have rights to a folder and perform the backup.

Refer to Lessons Learned Article LL#15834 for more issues about DBCreate.