Hi! I'm new to SSIS 2012 Project Deployment approach, but I successfuly deploy my project and I'm am able to run the packages via SSMS on the server where the packages are deployed. However, if I connect to the server using SSMS on my computer, I'm able to see the SSISDB Catalog and Execute the packages, but the execution fail when trying to access some network resources (source files to load in SSIS package are located on other servers).

I think it's a security impersonation problem, since remote execution needs to pass my windows credentials to the remote server. Is it possible to configure this on the invocation? or I need to grant some permissions on the remote server?

Thanks in advance.

Hi Losphie,

The account that is executing packages need permission on SSIS Catalog/SSISDB and also has access to the file share.Looks like you want to access files, so the account you used under proxy need to have access permissions.

HTH!

Prathy:)

Thankyou very much for your answer. I didn't used proxy accounts before, but, how do I configure my package to use the proxy account instead of my windows credentials or whatever it's using to execute the package? is the package running on the remote server or on my machine? also, I really do not understand why I need a linked server. I really appreciate any guidance on this trouble, since I need to deploy more packages to be executed from end user's computers and can't give every user a terminal server license to connect by remote desktop to the server hosting the packages.

Best regards!

Hello Prathy. The account already have the right permissions over SSISDB / SSIS Catalog and the network resources. My problem is that, if I execute the package from ssms, connected on the server that hosts SSIS Catalog using windows authentication, there is no problem with the execution. Problem arise when I do the same but connected to the database engine using ssms with windows authentication from my computer. I supouse the problem is some kind of impersonation problem since the same account can execute the packages in both environments but remotely it causes an error.

Thankyou very much for your answer, hope you can help me a little more.

Best regards!

Hi Losphie,

Based on your description, it seems that you are facing the same issue as this thread. Please check the suggestions post by Doris Ji.

Thanks,
Katherine Xiong