Sunday, June 26, 2016

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.)
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


Post a Comment