英文:
The locale identifier (LCID) 8192 is not supported by SQL Server
问题
"我正在尝试进行事务复制，并在查看快照代理状态时遇到了以下异常：
区域标识符（LCID）8192 不受 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?
答案1
得分: 5
SQL Server在Windows上作为一个服务运行。这个服务由一个用户执行，每个用户都有特定的区域设置和本地标识符。SQL基本上只需要en_US区域设置，否则会出现问题。
要解决这个问题，首先可以更改运行服务的用户，看看是否能解决问题（对我来说有效）。转到Windows服务，右键单击SQL Server（MSSQLSERVER）>属性>登录>选中“本地系统帐户”单选按钮。然后右键单击SQL Server（MSSQLSERVER）再次点击重新启动以重新启动服务。
如果有效，那太好了！如果不行，将“Locale System账户”的区域设置更改为en_US，标识符更改为00000409。
转到RegEdit -> HKEY_USERS -> [SID本地管理员] -> 控制面板 -> 国际和更改所需区域的“Locale”和“LocaleName”键。如在不同的问题中所回答这里。
英文:
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
答案2
得分: 2
我是你的中文翻译。以下是翻译好的部分：
首先，检查 Services 中运行 SQL Server (MSSQLSERVER) 的用户是谁：
接下来，打开 Registry Editor 并导航到 Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList\。找到用户的ID。在我的情况下，用户 MSSQLSERVER 的ID是 S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003：
当你获得了用户的ID后，在Registry Editor中，转到路径 Computer\HKEY_USERS\[USER ID]\Control Panel\International。在我的情况下，路径是 Computer\HKEY_USERS\S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003\Control Panel\International。在那里你会找到两个名为 Locale 和 LocaleName 的键：
在我的情况下，它们具有以下值：
Locale=00000c00LocaleName=en-SE
将它们更改为：
Locale=00000409LocaleName=en-US
接下来，重新启动服务 SQL Server (MSSQLSERVER)。
在我的情况下，我想部署一个SSIS包到SQL Server，在我做了这个更改后它正常工作了。
英文:
I solved it in the following way.
First, check in Services which user SQL Server (MSSQLSERVER) runs as:
Next, open the Registry Editor and navigate to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList\. Find which ID the user has. In my case, the user MSSQLSERVER has the ID S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003:
When you have the user's ID, in the Registry Editor, go to the path Computer\HKEY_USERS\[USER ID]\Control Panel\International. In my case, the path is Computer\HKEY_USERS\S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003\Control Panel\International. There you will find two keys named Locale and LocaleName:
In my case, they had the following values:
Locale=00000c00LocaleName=en-SE
Change them to:
Locale=00000409LocaleName=en-US
Next, restart the service SQL Server (MSSQLSERVER).
In my case, I wanted to deploy an SSIS package to SQL Server, and it worked after I had done this change:
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论