0

I was attempting to use Ola Hallengren's scripts to backup to a remote NAS, but it was failing and not giving any direct errors, so I tried doing it manually using Server Management Studio and got the following error:

TITLE: Microsoft SQL Server Management Studio

------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The operating system returned the error '0x80070005(Access is denied.)' while attempting 'SvlPathDoesPathExist' on '\Dl-nas-01\LOCAL FILE BACKUP\OLASQL'. The statement has been terminated. (Microsoft SQL Server, Error: 3634)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=14.00.2002&EvtSrc=MSSQLServer&EvtID=3634&LinkId=20476


Now, the account I am signed into has FULL permission and access to that share, my connection is my domain\myaccount, and from the VM I can even put \\Dl-nas-01\LOCAL FILE BACKUP\OLASQL into a folder browser and access it.

Does SQL Server run these from a different account I don't know about? Backing up to a local location works fine, what's the solution? I'm pretty lost.

2

You mentioned this is a NAS, but this doesn't look like a valid network path:

\Dl-nas-01\LOCAL FILE BACKUP\OLASQL

Try using two slashes at the beginning, like this:

\\Dl-nas-01\LOCAL FILE BACKUP\OLASQL
2

Since you said you logged in to the server with a login and it got full permission to it. That doesn't mean that SQL server service running under the same. So make sure that the service login is having rights to access the folder. You can find the SQL server service login by doing the below steps.

Access your SQL Server configurartion manager mentioned in the thread here

To open SQL Server Configuration Manager, in the Search charm, under Apps, type:

SQLServerManager14.msc for [SQL Server 2017] or

SQLServerManager13.msc for [SQL Server 2016] or

SQLServerManager12.msc for [SQL Server 2014] or

SQLServerManager11.msc for [SQL Server 2012] or

SQLServerManager10.msc for [SQL Server 2008], and

then press Enter.

enter image description here

Right click on your SQL service and check under Log On to find the account highlighted above in the picture.

  • This was part of the problem, thank you so much! – Natsu Apr 9 at 21:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.