Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSIS Error while deploying package The locale identifier (LCID) is not supported by SQL Server

I get this error when deploying a package to SQL 2012 SSISDB catalog:

A .NET Framework error occurred during execution user-defined routine or aggregate "deploy-project-internal":

System.Data.SqlClient.SqlException: The locale identifier (LCID) 9242 is not supported by SQL Server 

......

like image 330
veljasije Avatar asked Jan 15 '14 10:01

veljasije


1 Answers

I had a very similar issue (different LCID) and took me weeks to resolve it but I hope is the same issue you where having and it helps for any other users.

So somehow something got bad installed on the SQL Server, the service account that is setup to run the SQL Server Service doesn't have all the necessary permissions.

I tracked this issue down to a very specific procedure, try to execute on the SSISDB the procedure [catalog].[check_schema_version] and you should be getting the same error message you are getting.

If executing the procedure gives you the same error, then the soultion is going to be the same. You basically need to change the account that is running SQL Server Service (not Integration Services) to be a local admin, and change the Locale on the RegEdit for that Local Admin acccount to be the one you want.

TO do so, do the following:

  • Execute on Command Prompt the following to get the SID:

    wmic useraccount where name='Administrator' get sid (Replace
    Administrator by your Local Admin Account)

  • Go to RegEdit -> HKEY_USERS -> [SID Local Admin] -> Control Panel -> International and change keys "Locale" and "LocaleName" for the
    desired region,(in my case it was Locale 00000409, LocaleName en-US)

  • Open Windows Services, look for the SQL SERVER (MSSQLSERVER) and
    change the running account to be your local admin

  • Restart the Service

That should be it. I figured all that out thanks to the combination of these 2 pages:

https://www.facebook.com/allaboutssis/posts/329497130467714

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9f409937-772a-41bd-8270-7804fdd5b94e/failure-in-deploying-ssis-project-from-ssdt-to-sqlserver-2014?forum=sqlintegrationservices&prof=required

like image 189
Hector Sanchez Avatar answered Nov 04 '22 09:11

Hector Sanchez