Deploy SSIS project to SQL Server but fails and causes SQL Server to stop

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

Javier Villegas 900 Reputation points MVP

2023-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

@Javier Villegas

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 points

2024-05-24T02:16:25.3866667+00:00

Hi Yu, Xueke (JP - AB 余雪柯)

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.

Share via

Deploy SSIS project to SQL Server but fails and causes SQL Server to stop