BizTalk Server 2013 – Unable to configure BAM
I was installing and configuring BizTalk Server 2013 for a client in a multi-server configuration (separate BizTalk application and BizTalk SQL servers). While configuring BAM, I received the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
Microsoft has released a hot fix for this issue:
To resolve the issue, apply the fix that is introduced in the following Microsoft Knowledge Base (KB) article:
Note KB 2830546 includes the fixes from KB articles 2830546, 2832136
I noticed that this was not an issue on single-server installations and you will not need to reboot the server after the patch – just restart host instances.