blocks|key|1183717|text|这可能不是100%25准确，但我就是这样理解的:+Server在Windows上作为服务运行。此服务由用户执行，每个用户都有特定的区域设置和本地标识符。SQL基本上只是想要一个en_US语言环境，因为否则它会搞砸一些事情。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1183718|为了解决这个问题，我们可以首先更改运行该服务的用户，并查看它是否修复了它(对我来说确实如此)。转到Windows，右键单击MSSQLSERVER+(MSSQLSERVER)+>+properties+>+Log+>勾选“”无线电按钮。再次右键单击MSSQLSERVER+(MSSQLSERVER)并单击“重新启动”重新启动服务。|1183719|如果成功的话，太好了！如果没有，则将locale帐户的区域设置更改为en_US，将id更改为00000409。转到RegEdit+->+HKEY_USERS+->+SID本地管理->控制面板->+International，并更改所需区域的"Locale“和"LocaleName”键。对另一个问题here的回答|offset|length|1183720|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/21135511/ssis-error-while-deploying-package-the-locale-identifier-lcid-is-not-supported^0|0|0|45|4|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

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 <a href="https://stackoverflow.com/questions/21135511/ssis-error-while-deploying-package-the-locale-identifier-lcid-is-not-supported">here</a>

blocks|key|2797134|text|我用以下方法解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2797135|首先，签入服务，哪个用户MSSQLSERVER+(MSSQLSERVER)运行为：|offset|length|style|BOLD|2797136|​|2797137|📷|atomic|2797138|2797139|接下来，打开注册表编辑器并导航到Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows+NT\CurrentVersion\ProfileList\。查找用户的ID。在我的示例中，用户MSSQLSERVER具有ID+S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003|CODE|2797140|2797141|2797142|2797143|当您有用户ID时，在注册表编辑器中，转到路径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的密钥|2797144|2797145|2797146|2797147|在我的例子中，它们具有以下值：|2797148|2797149|Locale+=+00000c00|unordered-list-item|2797150|LocaleName+=+en-SE|2797151|2797152|改为：|2797153|2797154|Locale+=+00000409|2797155|LocaleName+=+en-US|2797156|2797157|2797158|2797159|2797160|接下来，重新启动服务MSSQLSERVER+(MSSQLSERVER)。|2797161|在我的示例中，我希望将SSIS包部署到Server，并且在完成此更改之后，它工作了：|2797162|2797163|2797164|2797165|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/c81a6b7af1af12f5a70a7e4fa491b2f2.png|imageAlt|1|https://developer.qcloudimg.com/http-save/yehe-900000/ad733625bd7baf6e52f2c0a40f632391.png|2|https://developer.qcloudimg.com/http-save/yehe-900000/82a47663b0dc25656010de47803b816f.png|3|https://developer.qcloudimg.com/http-save/yehe-900000/16be1de6a4e7480e6b108099bd17603f.png|4|https://developer.qcloudimg.com/http-save/yehe-900000/3af48856b999cef7e5de352d06e019c1.png^0|0|5|2|C|P|0|0|0|1|0|0|0|6|6|3B|B|G|2D|3R|1R|0|0|0|1|1|0|0|M|1L|2I|33|5Y|6|65|A|0|0|0|1|2|0|0|0|0|0|6|9|8|0|0|A|D|5|0|0|0|0|0|6|9|8|0|0|A|D|5|0|0|0|0|1|3|0|0|A|P|0|0|0|0|1|4|0|0^^$0|@$1|2|3|4|5|6|7|26|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|27|8|@$D|28|E|29|F|G]|$D|2A|E|2B|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|2C|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|2D|8|@]|9|@$D|2E|E|2F|1|2G]]|A|$]]|$1|M|3|I|5|6|7|2H|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|2I|8|@$D|2J|E|2K|F|G]|$D|2L|E|2M|F|G]|$D|2N|E|2O|F|P]|$D|2P|E|2Q|F|P]]|9|@]|A|$]]|$1|Q|3|I|5|6|7|2R|8|@]|9|@]|A|$]]|$1|R|3|K|5|L|7|2S|8|@]|9|@$D|2T|E|2U|1|2V]]|A|$]]|$1|S|3|I|5|6|7|2W|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|2X|8|@$D|2Y|E|2Z|F|P]|$D|30|E|31|F|P]|$D|32|E|33|F|P]|$D|34|E|35|F|P]]|9|@]|A|$]]|$1|V|3|I|5|6|7|36|8|@]|9|@]|A|$]]|$1|W|3|K|5|L|7|37|8|@]|9|@$D|38|E|39|1|3A]]|A|$]]|$1|X|3|I|5|6|7|3B|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|3C|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|3D|8|@]|9|@]|A|$]]|$1|11|3|12|5|13|7|3E|8|@$D|3F|E|3G|F|P]|$D|3H|E|3I|F|P]]|9|@]|A|$]]|$1|14|3|15|5|13|7|3J|8|@$D|3K|E|3L|F|P]|$D|3M|E|3N|F|P]]|9|@]|A|$]]|$1|16|3|-4|5|6|7|3O|8|@]|9|@]|A|$]]|$1|17|3|18|5|6|7|3P|8|@]|9|@]|A|$]]|$1|19|3|-4|5|6|7|3Q|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|13|7|3R|8|@$D|3S|E|3T|F|P]|$D|3U|E|3V|F|P]]|9|@]|A|$]]|$1|1C|3|1D|5|13|7|3W|8|@$D|3X|E|3Y|F|P]|$D|3Z|E|40|F|P]]|9|@]|A|$]]|$1|1E|3|-4|5|6|7|41|8|@]|9|@]|A|$]]|$1|1F|3|I|5|6|7|42|8|@]|9|@]|A|$]]|$1|1G|3|K|5|L|7|43|8|@]|9|@$D|44|E|45|1|46]]|A|$]]|$1|1H|3|I|5|6|7|47|8|@]|9|@]|A|$]]|$1|1I|3|1J|5|6|7|48|8|@$D|49|E|4A|F|G]]|9|@]|A|$]]|$1|1K|3|1L|5|6|7|4B|8|@]|9|@]|A|$]]|$1|1M|3|I|5|6|7|4C|8|@]|9|@]|A|$]]|$1|1N|3|K|5|L|7|4D|8|@]|9|@$D|4E|E|4F|1|4G]]|A|$]]|$1|1O|3|I|5|6|7|4H|8|@]|9|@]|A|$]]|$1|1P|3|-4|5|6|7|4I|8|@]|9|@]|A|$]]]|1Q|$1R|$5|1S|1T|1U|A|$1V|1W|1X|-4]]|1Y|$5|1S|1T|1U|A|$1V|1Z|1X|-4]]|20|$5|1S|1T|1U|A|$1V|21|1X|-4]]|22|$5|1S|1T|1U|A|$1V|23|1X|-4]]|24|$5|1S|1T|1U|A|$1V|25|1X|-4]]]]

I solved it in the following way.
First, check in Services which user SQL Server (MSSQLSERVER) runs as:
<a href="https://i.stack.imgur.com/Erodv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Erodv.png" alt="enter image description here" /></a>
Next, open the Registry Editor and navigate to <code>Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList\</code>. Find which ID the user has. In my case, the user MSSQLSERVER has the ID <code>S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003</code>:
<a href="https://i.stack.imgur.com/64EOI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/64EOI.png" alt="enter image description here" /></a>
When you have the user's ID, in the Registry Editor, go to the path <code>Computer\HKEY_USERS\[USER ID]\Control Panel\International</code>. In my case, the path is <code>Computer\HKEY_USERS\S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003\Control Panel\International</code>. There you will find two keys named <code>Locale</code> and <code>LocaleName</code>:
<a href="https://i.stack.imgur.com/QdU2a.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QdU2a.png" alt="enter image description here" /></a>
In my case, they had the following values:
<ul>
<li><code>Locale</code> = <code>00000c00</code></li>
<li><code>LocaleName</code> = <code>en-SE</code></li>
</ul>
Change them to:
<ul>
<li><code>Locale</code> = <code>00000409</code></li>
<li><code>LocaleName</code> = <code>en-US</code></li>
</ul>
<a href="https://i.stack.imgur.com/PO6nD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PO6nD.png" alt="enter image description here" /></a>
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:
<a href="https://i.stack.imgur.com/Q7i5e.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Q7i5e.png" alt="enter image description here" /></a>

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

<blockquote>
 The locale identifier (LCID) 8192 is not supported by SQL Server
</blockquote>

What does it mean? Solution?

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

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

在查看快照代理状态时，我试图进行事务性复制并获取发布上的异常： Server不支持地区标识符(LCID) 8192什么意思？解决办法？

问Server不支持地区标识符(LCID) 8192
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Server不支持地区标识符(LCID) 8192EN