Receiving Operating System Error during a backup of CAREWare
Modified on Tue, 23 May 2017 14:31 by Kevin Ricciardo — Categorized as: Uncategorized
You are encountering the error:
"Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL$CAREWare\Data\cw_bu_X_X_X.cwb'. Operating system error 5(Access is denied." This error is most likely occurring because the user service used by SQL Server 2008 does not have the necessary permissions to write to the directory specified.
To resolve this error you can complete the following steps on the server where the SQL Server database is located.
Go to
C:\Program Files (x86)\Microsoft SQL Server\
.
Right click on the MSSQL$CAREWare directory.
Click
Properties
.
Click
Security
.
Click
Add
.
In the large, white box type
Network Service
.
Click
Check Names
.
Click
OK
.
Click the
Allow
check box for
Full Control
.
Click
Apply
.
Click
OK
.
This will grant the SQL Server user Network Service permissions to access, write, and modify files in the specified directory only. This should resolve the error you are encountering with the backups failing due to failed access.
Back to
Data Tier