SQL Agent cannot access UNC share

Question

I have a SSIS package which creates a folder in an UNC share and then creates a file there (using script task).

The domain account which is used by SSIS and Agent has all the possible permissions in the DB computer and the share computer.

It always fails there.

I created a test SQL Agent job which creates a backup of the database in the same location and it fails too (Operating system error 5 - access denied).

EDIT: The above test example may be irrelevant since the backup operation is executed by SQL Server Database Engine and not the SQL Agent itself (Agent still schedules the task).

I cannot debug the script task in SSIS and therefore Im not sure what is the problem.

Answer 1

I have managed to fix this problem. The first problem was lack of sufficient task activation/execution permissions in the DCOM config node in Component Services. The permissions had to be set for SQL Server Integration Services.

The second problem was the fact that the UNC path looked like this:

\\192.168.250.51\C$\Folder\

I needed to create another share (visible) like that:

\\COMPUTER-NAME\Folder\

Also don't try to map any drives to the folders. It won't work.