部署包时出现 SSIS 错误 SQL Server 不支持区域设置标识符 (LCID) [英] SSIS Error while deploying package The locale identifier (LCID) is not supported by SQL Server
问题描述
在将包部署到 SQL 2012 SSISDB 目录时出现此错误:
I get this error when deploying a package to SQL 2012 SSISDB catalog:
A .NET Framework error occurred during execution user-defined routine or aggregate "deploy-project-internal":
System.Data.SqlClient.SqlException: The locale identifier (LCID) 9242 is not supported by SQL Server
......
推荐答案
我遇到了一个非常相似的问题(不同的 LCID)，我花了数周时间才解决它，但我希望与您遇到的问题相同，并且对任何其他问题都有帮助用户.
I had a very similar issue (different LCID) and took me weeks to resolve it but I hope is the same issue you where having and it helps for any other users.
因此，SQL Server 上安装了一些错误的东西，设置为运行 SQL Server 服务的服务帐户没有所有必要的权限.
So somehow something got bad installed on the SQL Server, the service account that is setup to run the SQL Server Service doesn't have all the necessary permissions.
我将这个问题归结为一个非常具体的过程，尝试在 SSISDB 上执行过程 [catalog].[check_schema_version]，你应该得到与你得到的相同的错误消息.
I tracked this issue down to a very specific procedure, try to execute on the SSISDB the procedure [catalog].[check_schema_version] and you should be getting the same error message you are getting.
如果执行该过程给您相同的错误，那么灵魂将是相同的.您基本上需要将运行 SQL Server 服务(而不是集成服务)的帐户更改为本地管理员，并将该本地管理员帐户的 RegEdit 上的区域设置更改为您想要的帐户.
If executing the procedure gives you the same error, then the soultion is going to be the same. You basically need to change the account that is running SQL Server Service (not Integration Services) to be a local admin, and change the Locale on the RegEdit for that Local Admin acccount to be the one you want.
为此，请执行以下操作:
TO do so, do the following:
在命令提示符下执行以下内容以获取 SID:
Execute on Command Prompt the following to get the SID:
wmic useraccount where name='Administrator' get sid (Replace
由您的本地管理员帐户管理员)
wmic useraccount where name='Administrator' get sid (Replace
Administrator by your Local Admin Account)
转到 RegEdit -> HKEY_USERS -> [SID Local Admin] -> 控制面板 ->
的国际和更改键Locale"和LocaleName"所需的区域，(在我的例子中是 Locale 00000409，LocaleName en-US)
Go to RegEdit -> HKEY_USERS -> [SID Local Admin] -> Control Panel ->
International and change keys "Locale" and "LocaleName" for the
desired region,(in my case it was Locale 00000409, LocaleName en-US)
打开 Windows 服务，查找 SQL SERVER (MSSQLSERVER) 和
将运行帐户更改为您的本地管理员
Open Windows Services, look for the SQL SERVER (MSSQLSERVER) and
change the running account to be your local admin
重启服务
应该是这样.多亏了这 2 页的组合，我才明白这一切:
That should be it. I figured all that out thanks to the combination of these 2 pages:
https://www.facebook.com/allaboutssis/posts/329497130467714
这篇关于部署包时出现 SSIS 错误 SQL Server 不支持区域设置标识符 (LCID)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
