Configuring Biztalk across Remote SQL Server
vamsi
I would like to Share information about configuring Biztalk while
configuring the databases on a remote SQL Server Machine.This
information should be valid for people who are trying to configure
Biztalk on a Remote Sql Server Machine either in the same domain or a
different domain.My implementation involves Biztalk and Sql Server on
Win 2000 Server.Problems like
"Failed to
deploy BizTalk system assembly "C:\Program Files\Microsoft BizTalk
Server 2004 Microsoft.BizTalk.GlobalPropertySchemas.dll". Unspecified
exception: An error occurred while enlisting in a distributed
transaction."
"Failed to
deploy BizTalk system assembly "C:\Program Files\Microsoft BizTalk
Server 2004
Microsoft.BizTalk.GlobalPropertySchemas.dll". Unspecified
exception:Eventlog is full"
Assumptions:
1.Sql Server is installed on the remote Maching with all the Biztalk
requisites.
2.MSDTC is installed on both the Biztalk and SQL Box.Include MSDTC in
the firewall exceptions if any.
3.Try pinging the machines ,from each other.If necessary trouble shoot
using the DTCping tool.Look for DTCPing.exe in the below link.
http://support.microsoft.com/default.aspx?scid=kb;en-us;306843
4.If you get the error which says "your eventlog is full",Make sure you
clear you the Eventlog on both the Servers hosting biztalk and SQL
Server.Clear Event log by using Eventviewer.
Run-->eventvwr.msc
Make a copy of the previous eventviewr information if necessary.
5.Open ports for network TCP/IP 5000-5200.
Administrative Tools-->Component Services-->My Computer-->Right Click
-->Properties-->Default Protocols Tab-->Conn Oriented Tcp/IP-->ADD
5000-5200 port range.
6.These were the above steps i took to get Biztalk Configuration
installed across MultiServer.
Let me know how this works and mail me if you have any questions.Feel
free to correct my diagnosis.
Thank you,
Vamsi