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

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:

• Cumulative Update 6 for BizTalk Server 2016

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