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

Remove Cookies From CookieContainer Class

How To Test Or Check Dead Pixels And Backlight Bleed On Your Monitor Using Dead Pixel Checker In Windows 11