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
