Welcome on my blog about the Microsoft Dataplatform!
My name is Marc van der Wielen, expert in and passionate about the Microsoft dataplatform.
On this blog I will share my experience and tips & tricks about mostly Microsoft SQL Server, Intergation Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), Power BI, BIML, DAX, MDX, T-SQL etc.
Visit LinkedIn: Marc van der Wielen
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.