Issue
Unable to restore a taclogdata database in SQL Management Studio. The following error message occurs:
"An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo). Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\XXXX.bak'. Operating system error 5(Access is denied.). RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)"
Environment
SQL Management Studio - all versions (express 2005, 2008 etc).
Vista 5.X
Cause
The SQL server does not have the authority to access the back up file (.bak).
Resolution
1. Identify which account is running the TAC Vista SQL Server
a. Open Services - Start\Settings\Control Panel\Administrative Tools\Services.
b. Locate the SQL Server (TACVISTA) service.
c. In the "Log on as" column, make a note of the user account being used. In the example below the "Network Services" account.
2. Locate the back-up file
3. Change the security settings for the back-up file
a. Right-click on the file and select Properties.
b. If not already added, add the user account you noted step 1.c and grant the account full control permission for the file.
It should now be possible to restore the backup.
