FIX: Visual Studio is unable to deploy BizTalk project to SQL Server when there is unrelated database >2TB on the same SQL Server with BizTalk Server

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

Symptoms


Assume that you have a database that is greater than 2TB size on the same Microsoft SQL Server with BizTalk Server. In this situation, you will not be able to use Microsoft Visual Studio to deploy BizTalk projects to SQL Server.

After specifying the SQL Server name, the deployment UI will fail to retrieve BizTalkMgmtDb with an error message:  Specified cast is not valid.

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:

2003907 Information about BizTalk hotfixes and Cumulative Update support