Thursday, August 20, 2009

Configuring Biztalk across Remote SQL Server

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.

No comments: