Operating System Error 5(Access is denied.) "Cannot open backup device" in SQL Server
Here's how I manage to solve the issue Cannot open backup device with status Operating system error 5(Access is denied.)
Steps
1. Right Click the Folder which is the backup destination
2. Click Properties -> Security Tab -> Click Advanced Button
3. On Permissions Tab -> choose Add -> Select Principal
4. In the "Enter the object name to select", type "NT Service\MSSQLSERVER". -> OK
Note: NT Service\MSSQLSERVER is the Log On As value of MSSQLSERVER service under Services. See screenshot below
5. In Multiple Names Found choose MSSQLSERVER.
6. Click OK
7. In Basic permissions panel, Choose Full Control
8. Click Apply -> OK -> OK to close Folder Properties dialog box
SQL Server Service
Steps
1. Right Click the Folder which is the backup destination
2. Click Properties -> Security Tab -> Click Advanced Button
3. On Permissions Tab -> choose Add -> Select Principal
4. In the "Enter the object name to select", type "NT Service\MSSQLSERVER". -> OK
Note: NT Service\MSSQLSERVER is the Log On As value of MSSQLSERVER service under Services. See screenshot below
5. In Multiple Names Found choose MSSQLSERVER.
6. Click OK
7. In Basic permissions panel, Choose Full Control
8. Click Apply -> OK -> OK to close Folder Properties dialog box
SQL Server Service
Comments
Post a Comment