Navigation¶

• FAQ
• Feature Explorer
• All CAREWare documentation
• All Pages
• Create Account
  

Quick Search
»

Receiving Operating System Error during a backup of CAREWare

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.

1. Go to C:\Program Files (x86)\Microsoft SQL Server\.
2. Right click on the MSSQL$CAREWare directory.
3. Click Properties.
4. Click Security.
5. Click Add.
6. In the large, white box type Network Service.
7. Click Check Names.
8. Click OK.
9. Click the Allow check box for Full Control.
10. Click Apply.
11. 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