This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 53%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
We have a production server where we have several SSIS packages. These packages run fine when scheduled via a job and I can run them via SSMS when I remote into the server/VM.
However, when I connect to the server via SSMS on my local machine and try to execute/validate a package it just says Pending execution.
Is there something I need to do to make it work via SSMS from my local machine?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Hi @Vivek Devalkar ,
That's the nature of the beast.
You need to be on the SSIS server via Remote Desktop or Kerberos settings should be setup properly.
Good link on the subject: Getting Cross Domain Kerberos and Delegation working with SSIS Package
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Hi @Vivek Devalkar ,
1.Please run the ssis package in catalog again.
2.Could you please check if the user in ssis catalog has full permissions to run the ssis package?
3.Please refer to Integration Services Roles (SSIS Service).
Best regards,
Mona
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Yes, my user id now has ssis_admin as well as db_admin roles in the SSIS Catalog DB but it still did not work.
We have another sandbox server too and I am able to run packages on that server via my machine (SSMS). It doesn't work only in the Production server so I'm guessing it has something to do with permissions.
Only difference between the Sandbox server and the production server as far as how the packages function is that in Production, data is loaded into a database that is on another server whereas in Sandbox both the package and the destination database are on the same server.
I hope you didn't miss my answer.
There is nothing else in addition to what already outlined in my answer.
No didn't miss. Was just hoping there is some other simple solution :)
Still feel like it's just something I am missing given it works in our Sandbox environment.
Hi @Vivek Devalkar ,
We have another sandbox server too and I am able to run packages on that server via my machine (SSMS). It doesn't work only in the Production server so I'm guessing it has something to do with permissions.
Please give full permissions for the user in Production server to access the SSIS packages.
Then please re-execute the ssis packages in SSMS.
Best regards,
Mona