Topics

SSIS deployment: Error The locale id (LCID) 8192 is not supported


When deploying an ispac or package(s) to SQL server you may encounter the following error:"The locale (LCID) 8192 is not supported".

The cause of the problem is the fact SQL server is using the wrong locale settings in the account SQL server uses to run.

First figure out the name of the accounts SQL server uses to run. Normally the account name is "MSSQLSERVER". Check the account name by running "services.msc", go to "SQL Server", check the account name under the "Log on" tab.



Start the registry editor (regedit), go to the "Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList\" to find the folder containing the "ProfileImagePath" with the name "MSSQLSERVER". The name of the folder is the SID (Security Identifier). You need the SID in the next step to change the Locale and LocaleName property.




Navigate to "Computer\HKEY_USERS\S-.........................\Control Panel\International" and change "Locale" to "00000409" and "LocalName" to "en-US".



Restart SQL server and the issue is solved.