Donate

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
Operating System Error 5(Access is denied.) Cannot open backup device in SQL Server

Comments

Donate

Popular Posts From This Blog

WPF CRUD Application Using DataGrid, MVVM Pattern, Entity Framework, And C#.NET

How To Insert Or Add Emojis In Microsoft Teams Status Message

TypeScript Error Or Bug: The term 'tsc' is not recognized as the name of a cmdlet, function, script file, or operable program.