Hardware and Software Requirements for BizTalk Server 2013 and 2013 R2
Hardware and Software Requirements for BizTalk Server 2013 and 2013 R2 does not mention whether you should install 32-bit or 64-bit of SQL Server
.
BizTalk Server 64-Bit Support
There is a good reason for this according to BizTalk Server 64-Bit Support from MSDN
,
So, it makes sense and this seems to be the case for most of other BizTalk components.
Issue
However, when it comes to installing UDDI Services Database Component, you will encounter following issue.
Resolution
Install 64-bit
version of SQL Server
. This fixes the issue as follows.
I wish I could tell why this happen but I would rather toss that question to Microsoft
. I belive this is a product bug. If not, it should be mentioned clearly somewhere in MSDN
.
Environment
Following was my test environment setup. Please add your experience in comment if you have witnessed same or different behavior.