SqlBak Blog

Destination error: “Access is denied”

In this article we would like to bring a very rare and interesting case to your attention. Assume you use SqlBak, everything is up and running perfectly, backups are made as scheduled and then stored in the folder you specified, everything seems flawless.

Problem

Then you get the following error message out of the blue:

Connecting to Folder destination "\\sql\s$\SQLBak\SQL" 
8:46:52 PM 
Destination error: [DST-1:1001#102] Failed to open "\\sql\s$\SQLBak\SQL" destination connection. > Access is denied

In this case users usually verify the following folder destination settings: username and password. Everything is correct, but the error occurs again. The reason behind this error message is that UAC remote restrictions are enabled or have “0” value meaning that this value builds a filtered token. This is the default value. Administrator credentials are removed. Note that UAC or User Account Control is a new security component of Windows.

Solution

The solution to this issue is pretty simple. All you have to do is to disable UAC remote restrictions. In other words, it is necessary to set up UAC remote setting value from “0” to “1” to do it:

  1. Click “Start”, then “Run”, type “regedit” command and press “ENTER”
  2. Find the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System
  3. Right-click “LocalAccountTokenFilterPolicy”, and choose “Modify”.
  4. Type “1” in the opened data box, and then click OK.

Make sure to reboot your computer for the changes to take effect.

Leave a Comment