Error deployment from SSIS to SQL Server

Question

I tried to deploy project from ssis (visual studio) to SQL server and i got this error :

TITLE: SQL Server Integration Services
------------------------------

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, Action`1 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, TaskCompletionSource`1 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)
. (Microsoft SQL Server, Error: 6522)

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

------------------------------
BUTTONS:

OK
------------------------------

Answer 1

Hi @ikram elmbarki,

The locale identifier (LCID) 14348 is not supported by SQL Server

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 Hui

---

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