MS SQL Server 2016 SSIS Failed to deploy project. Error:27203

Question

MS SQL Server 2016 SSIS Failed to deploy project. Error:27203

Ugur 0

Hello. I have MS SQL Server 2016 and Integration Services 13.0 installed. I am able to create SSIS packages via Visual Studio 2022 and run them successfully. But I cannot deploy the SSIS packages on SQL Server. I created Integration Services Catalog and folder but I am getting "Failed to deploy project. Error:27203" error when I try to deploy it. I had different names of @@SERVERNAME and SERVERPROPERTY('SERVERNAME') but I solved it via this link
https://stackoverflow.com/questions/63797484/ssis-failed-to-deploy-project-error-27203

EXEC sp_dropserver 'oldservername';  
GO  
EXEC sp_addserver 'newservername', local;  
GO

but still no use (I restarted SQL Server afterwards yet I still get the same error).

"Select * from SSISDB.catalog.operation_messages" gives me nothing. I don't know what to do. Everything seem to work fine. I have no idea what to do now.

F.Y.I its not due to the version of Visual Studio 2022. I was able to deploy packages with same Visual Studio version into SQL Server 2012. SSIS_ERROR_2

SSIS_ERROR

Olaf Helper 47,436 Reputation points

2023-10-16T17:03:50.5666667+00:00

Click on "Show details" for more details.

Ugur 0

===================================

Failed to deploy project. For more information, query the operation_messages view for the operation identifier '43'. (.Net SqlClient Data Provider)

------------------------------
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-27203-database-engine-error

------------------------------
Server Name: ZEPSQL02
Error Number: 27203
Severity: 16
State: 1
Procedure: deploy_project
Line Number: 139


------------------------------
Program Location:

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.SqlServer.IntegrationServices.Common.ObjectModel.SqlHelper.ExecuteSQLCommand(SqlStoreConnection storeConnection, CommandType cmdType, String cmdText, SqlParameter[] parameters, ExecuteType execType, Int32 commandTimeout)
   at Microsoft.SqlServer.Management.IntegrationServices.CatalogFolder.DeployProject(String projectName, Byte[] projectStream)
   at Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model.DeploymentModel.Deploy(CatalogFolder folder, Project project)
   at Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model.DeploymentModel.DeployProject()
   at Microsoft.SqlServer.IntegrationServices.Deployment.DeployProjectPage.DoWork(Object sender, DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

1 answer

Your answer

Olaf Helper 47,436 Reputation points

2023-10-16T17:03:50.5666667+00:00

Click on "Show details" for more details.

Answer 1

Hi @Ugur

SQL Server 2016 is not supported as target server version. (Target server versions supported are SQL Server 2017, 2019 and 2022.)

F.Y.I its not due to the version of Visual Studio 2022. I was able to deploy packages with same Visual Studio version into SQL Server 2012.

It's confused why you could deploy to SQL Server2022, could you please try to use VS2019 to deploy the package?

You may also try to deploy the packages with SSMS or command to see if it could succeed.

Deploy a project to the Integration Services Server

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.

Share via

MS SQL Server 2016 SSIS Failed to deploy project. Error:27203

1 answer

Your answer