sql-servertransactional-replication

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


I am trying to make transactional replication and getting the exception on publications while viewing the snapshot agent status:

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

What does it mean? Solution?


Solution

  • This might not be 100% accurate but it is how I understand it: SQL Server runs as a service on Windows. This service is executed by a user, and every user has a specific locale and local identifier. SQL basically just wants an en_US locale because otherwise it messes something up.

    To solve this we can first change the user that runs the service and see if that fixes it (it did for me). Go to Windows Services, right click SQL Server (MSSQLSERVER) > properties > Log On > Tick the 'Local System account' radiobutton. Restart the service by right clicking SQL Server (MSSQLSERVER) again and clicking restart.

    If it works, great! If it doesn't, change the locale of the Locale System account to en_US and the id to 00000409. Go to RegEdit -> HKEY_USERS -> [SID Local Admin] -> Control Panel -> International and change keys "Locale" and "LocaleName" for the desired region. As answered on a different question here