FIX: BizTalk setup fails on case-sensitive collations due to mismatched case 'nId' instead of 'nID' in BizTalkMgmtDb

Applies to: BizTalk Server 2016 BranchBizTalk Server 2016 DeveloperBizTalk Server 2016 Enterprise

Symptoms


Assume that you install Microsoft BizTalk Server on an instance of BizTalkMgmtDb that is in case-sensitive collation. For example, Finnish_Swedish_CS_AS. In this scenario, the installation may fail because the mismatched case 'nId' is used instead of 'nID' in BizTalkMgmtDb. Additionally, you may receive the following error message:
"Server = xxxxxxx Database = BizTalkMgmtDb
Taking Backup of tables
Getting Id of Microsoft.BizTalk.GlobalPropertySchemas
SQL Exception occured. An error occured while adding Microsoft.BizTalk.GlobalPropertySchemas
Invalid column name 'nId'."

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. 

Resolution


This problem is fixed in the following cumulative update for BizTalk Server:

References


For information about the service packs and cumulative update list for BizTalk Server, see the following article in the Microsoft Knowledge Base:

2555976 Service pack and cumulative update list for BizTalk Server

For more information about BizTalk Server hotfixes, see the following article in the Microsoft Knowledge Base:

2003097 Information about BizTalk hotfixes and Cumulative Update support