Cannot Open Backup Device - Operating System Error 5
When you are trying to create a backup of Clarity or restore a backup into Clarity, you may receive the following error message: Cannot open backup device 'X:\destination'. Operating system error 5 (access is denied.). The backup or restoration of a backup then fails. This happens because Clarity uses the SQL server to manage your Clarity data. So, if you do not have the correct security rights or permissions to create the backup and run SQL services, the process will fail.
Note: This article only contains instructions to resolve this error on SQL version 2005 through 2014. If you have an older or newer version of SQL, please contact our support team.
Solution
If SQL Server Configuration Manager is installed:
- Open SQL Server Configuration Manager.
- Go to SQL Server 2XXX Services. For example, if you are running SQL version 2014, it will say 'SQL Server 2014 Services'.
- Right-click on the Database Instance Service.
- Select "Properties".
- Go to the 'Log On' tab.
- Change the option “Log on as:” from "This Account:" to "Built-in Account".
- Set the user account to “Local System”.
- Restart the database SQL Service.
If SQL Server Configuration Manager is not installed:
- In your Windows operating system, navigate to the Control Panel. You can typically find this in your 'Start' menu.
- Select “Administrative Tools”. This will open a second window for Administrative Tools.
- Double-click "Services". This will open a third window for Services.
- In the 'Extended' tab, search for "SQL Server (AKM2XXX)" or "SQL Server (AKMUS)".
- Right-click on it and select “Properties”.
- Navigate to the 'Log On' tab.
- Change the option "Log on as:" from "This Account:" to "Local System Account".
- Restart the Database Service.
