M
M
MainZerg2017-12-27 16:27:07
Backup
MainZerg, 2017-12-27 16:27:07

How to force MsSQL to log in to a file share with an AD account?

There is a NAS connected to the domain. There is a ball on it, with access rights for a specific user.
Backup is done using a maintenance plan. SQl agent under the required domain account.
From under Windows access to the folder is. MSSQL in logs swears as far as I understand on authorization.
Failed with the following error: "Cannot open backup device '\\*NASPATH*'. Operating system error 5(error not found). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not s... The package execution fa... The step failed.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Artem Kiryanov, 2017-12-27
@hacker342

Is this sphere and rights added to AD?
The error says that he cannot open the device, because there are not enough rights in AD, most likely this checkbox is missing:
5a43a436b66c5602289378.png

D
d-stream, 2017-12-28
@d-stream

Apparently it will be necessary by the "poke method": we give the rights to the ball to everyone, after the backup has worked - we look who (which account) is the "author" of the file. We think.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question