SSIS Error when deploying package , The Local identifier 14348 is not supported by SQL Server

Question

I am unable to deploy my project from Visual Studio to SSISDB. I have tried to change my localename and locale as well as my region. I have also made MYSQL Server login local but the below error still persists. Can anyone provide guidance
<WizardReport xmlns="http://schemas.datacontract.org/2004/07/Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><Results><Children/><Header>Results</Header><ReportItems><SummaryReportItem><Message i:nil="true"/><Property>Loading project</Property><Status>Success</Status><Value i:nil="true"/></SummaryReportItem><SummaryReportItem><Message i:nil="true"/><Property>Connecting to destination server</Property><Status>Success</Status><Value i:nil="true"/></SummaryReportItem><SummaryReportItem><Message i:nil="true"/><Property>Changing protection level</Property><Status>Success</Status><Value i:nil="true"/></SummaryReportItem><SummaryReportItem><Message>A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal":
System.Data.SqlClient.SqlException: The locale identifier (LCID) 14348 is not supported by SQL Server.
System.Data.SqlClient.SqlException:
à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
 à System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)
 à System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)
 à System.Data.SqlClient.SqlDataReaderSmi.NextResult()
 à System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
 à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
à System.Data.SqlClient.SqlCommand.ExecuteScalar()
à Microsoft.SqlServer.IntegrationServices.Server.ServerConnectionControl.GetServerProperty(String propertyName)
à Microsoft.SqlServer.IntegrationServices.Server.ServerConnectionControl.GetSchemaVersion()
à Microsoft.SqlServer.IntegrationServices.Server.ISServerExecArgumentBuilder.ToString()
à Microsoft.SqlServer.IntegrationServices.Server.ServerApi.DeployProjectInternal(SqlInt64 deployId, SqlInt64 versionId, SqlInt64 projectId, SqlString projectName)
.</Message><Property>Deploying project</Property><Status>Failure</Status><Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">System.Data.SqlClient.SqlException (0x80131904): A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal":
System.Data.SqlClient.SqlException: The locale identifier (LCID) 14348 is not supported by SQL Server.
System.Data.SqlClient.SqlException:
à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
 à System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)
 à System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)
 à System.Data.SqlClient.SqlDataReaderSmi.NextResult()
 à System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
 à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
à System.Data.SqlClient.SqlCommand.ExecuteScalar()
à Microsoft.SqlServer.IntegrationServices.Server.ServerConnectionControl.GetServerProperty(String propertyName)
à Microsoft.SqlServer.IntegrationServices.Server.ServerConnectionControl.GetSchemaVersion()
à Microsoft.SqlServer.IntegrationServices.Server.ISServerExecArgumentBuilder.ToString()
à Microsoft.SqlServer.IntegrationServices.Server.ServerApi.DeployProjectInternal(SqlInt64 deployId, SqlInt64 versionId, SqlInt64 projectId, SqlString projectName)
.
à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
 à System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
à System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
à System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
à 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)
à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
 à System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
à System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
à Microsoft.SqlServer.IntegrationServices.Common.ObjectModel.SqlHelper.ExecuteSQLCommand(SqlStoreConnection storeConnection, CommandType cmdType, String cmdText, SqlParameter[] parameters, ExecuteType execType, Int32 commandTimeout)
à Microsoft.SqlServer.Management.IntegrationServices.CatalogFolder.DeployProject(String projectName, Byte[] projectStream)
à Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model.DeployExportProjectHelper.DeployProject(CatalogFolder folder, String projectName, MemoryStream projectStream)
à Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model.DeploymentModel.Deploy(CatalogFolder folder, String projectName, MemoryStream projectStream)
à Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model.DeploymentModel.DeployProject()
ClientConnectionId :606043b6-292f-4051-b3f2-182177232de1
Error Number :6522,State :1,Class :16</Value></SummaryReportItem></ReportItems></Results><Summary><ReportSection><Children/><Header>Use the following arguments to perform this deployment from the command line:</Header><ReportItems><SummaryReportItem><Message/><Property>Command line</Property><Status>None</Status><Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">/Silent /ModelType:Project /SourcePath:"C:\Users\Micro\source\repos\Formation_SSIS\Déploiement d'un projet\bin\Development\Déploiement d'un projet.ispac" /DestinationServer:"DESKTOP-5AKSM5D" /DestinationPath:"/SSISDB/PackageGestionFichier/Déploiement d'un projet"</Value></SummaryReportItem></ReportItems></ReportSection><ReportSection><Children/><Header>Source</Header><ReportItems><SummaryReportItem><Message/><Property>Path</Property><Status>None</Status><Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">C:\Users\Micro\source\repos\Formation_SSIS\Déploiement d'un projet\bin\Development\Déploiement d'un projet.ispac</Value></SummaryReportItem></ReportItems></ReportSection><ReportSection><Children/><Header>Destination</Header><ReportItems><SummaryReportItem><Message/><Property>Server name</Property><Status>None</Status><Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">DESKTOP-5AKSM5D</Value></SummaryReportItem><SummaryReportItem><Message/><Property>Path</Property><Status>None</Status><Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">/SSISDB/PackageGestionFichier/Déploiement d'un projet</Value></SummaryReportItem></ReportItems></ReportSection></Summary></WizardReport>

I changed my local setting to :
"Locale" change to 00000409
"LocaleName" change to "en-US"

But I can't deploy my ipac file.
Thanks for help

Answer 1

Hi @ikram elmbarki ,

You may try below methods for a try.

Method1:
Go to SSMS-->Go To Security-->Logins-->Right Click on your username and select Properties-->Change the default language to English

Method2:
Go to RegEdit -> HKEY_USERS -> [SID Local Admin] -> Control Panel -> International and change keys "Locale" and "LocaleName" for the desired region.

Method3:
Go to Windows Services, right click SQL Server (MSSQLSERVER) > properties > Log On > Tick the 'Local System account'. Restart the service by right clicking SQL Server (MSSQLSERVER) again and clicking restart.

Don't forget to restart SQL Sever.

Reference: http://www.vdwielen.net/2018/12/ssis-deployment-error-locale-id-lcid.html

https://stackoverflow.com/questions/21135511/ssis-error-while-deploying-package-the-locale-identifier-lcid-is-not-supported

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.