Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Issue

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'

Product Line

TAC INET

Environment

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

Cause

The cause is insufficient rights to perform this function based upon a local policy of not allowing users to see the 'C' drive.

Resolution

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. 

  1. Go to local disk properties - security tab
  2. Users do not have permissions to modify or write to the 'C' drive. Windows UAC may over ride the administrator permissions.
  3. 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.


 

Tags (1)
Labels (1)
Version history
Revision #:
5 of 5
Last update:
Friday
Updated by: