SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,500 questions
Deploy SSIS project to SQL Server but fails and causes SQL Server to stop
![](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(108.80000000000001, 23%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYX%3C/text%3E%3C/svg%3E)
Yu, Xueke (JP - AB 余 雪柯)
0
Reputation points
Hello,
I am trying to deploy a SSIS project and have already created the Integration Service Catalogs folder necessary.
However, when the deployment happens, it fails and gives the following error message
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The handle is invalid.)
And as a result the destination SQL Server always stops after the deployment fails.
Is there a reason why. Thanks in advance.
Best,
Roxie
{count} votes
-
Javier Villegas 900 Reputation points MVP2023-12-01T14:53:41.4466667+00:00 Hello
Are you able to connect to that instance using Management Studio from the machine that you are launching the deployment ?
Regards
Javier
-
Yu, Xueke (JP - AB 余 雪柯) 0 Reputation points
2023-12-03T23:32:10.0166667+00:00 Thank you for the comment. Yes, I was able to connect to the SQL Server before I started the deployment.
A further look into the error log seems to suggest that the SQL Server is shut down forcibly due to C2 audit tracing (?). It was advised that I should disable C2 audit tracing, but since I do not have full control over the configuration of the softwares, I am still checking to see if that is possible.
Meanwhile it would be much appreciated if you know another solution might be available. Thank you so much!
-
Ruel G. Cabusas 205 Reputation points2024-05-24T02:16:25.3866667+00:00 Why there is a C2 audit tracing? Who run it and can you try disabling it for a moment so you can try to deploy your SSIS Package? This generate a lot of data and your resources might not be sufficient enough to run this audit or it should be an attended activity if you don't have lots of spare resources.
Sign in to comment