DBCreate backup access denied using Windows Server 2008 R2 Standard & Microsoft SQL 2008 R2
'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'
I/NET loaded on Windows Server 2008 R2 Standard & Microsoft SQL 2008 R2
The cause is insufficient rights to perform this function based upon a local policy of not allowing users to see the 'C' drive.
Although when Using a Network Administrator account or Administrator for the local machine, 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.
- Go to 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 How to Troubleshoot on DBCreate for more issues about DBCreate.