Azure SQL MI - Azure SSIS-IR的排序规则问题 [英] Azure SQL MI - Collation Problems with Azure SSIS-IR

问题描述

如果您更改数据库的排序规则，是否有人知道为什么Azure SSIS-IR不再起作用？无法打开Integration Services目录...

请参阅：  https://twitter.com/matthiasnohl/status/1111266013746728960？s = 12

最佳

马蒂亚斯

解决方案

Hello，

As您可以直接从Microsoft员工阅读以下MSDN论坛帖子，不支持更改SSIS
目录数据库的排序规则。



https://social.msdn.microsoft.com/Forums/ en-US / 4802b478-bffb-469b-be5e-20b3c562a0c4 / ssisdb-collat​​ion-default-how-to-change？forum = sqldenintegrationservices

希望这会有所帮助。

问候，

Alberto Morillo

SQLCoffee.com

Does anyone know why the Azure SSIS-IR doesn't work anymore if you change the collation of the database? The Integration Services Catalog cannot be opened...

See: https://twitter.com/matthiasnohl/status/1111266013746728960?s=12

Best

Matthias

解决方案

Hello,

As you can read on the following MSDN forum thread, directly from a Microsoft employee, changing the collation of a SSIS Catalog database is not supported.

https://social.msdn.microsoft.com/Forums/en-US/4802b478-bffb-469b-be5e-20b3c562a0c4/ssisdb-collation-default-how-to-change?forum=sqldenintegrationservices

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

这篇关于Azure SQL MI - Azure SSIS-IR的排序规则问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！