In
Microsoft BizTalk Server 2006 R2, you import a BizTalk application .msi file by
using the BizTalk Administration console. Then, you try to import the same
BizTalk application .msi file again. When you do this, the number of connections to Microsoft SQL Server
may increase to over 500. The number of connections to SQL Server does not decrease even
after the import operation has finished.
Additionally, the import
operation may be unsuccessful, and you may receive the following error message:
Import fails with the following: Timeout expired. The timeout
period elapsed prior to obtaining a connection from the pool. This may have
occurred because all pooled connections were in use and max pool size was
reached. (Microsoft.BizTalk.ExplorerOM)
This problem occurs only when
you import the same BizTalk application .msi file again. This problem does not
occur when you first deploy the BizTalk application .msi file.
Note You can examine the number of connections to SQL Server by running the
following query in SQL Server.
Select count(*) from sysprocesses