So we all know that DTC often provides problems, and it can be a hassle. I’ve spent so much time waiting for everything to get up, and I often find myself spending most of my time With the actual configuration of BizTalk.
It is important to maintain a high level of security, one of the ways to do this is to use a firewall between the servers, what type of communication is allowed between the machines and over what ports, TCP, UDP, ports or port ranges.
So I’m willing to share one of the elements that most often are the actual problem.
The MSDTC will by default use port 135, however, it will also use a wide range of ports to send and receive data. It is important that you configure both the BizTalk and SQL Server machines to allow these ports to be used and set up a port range.
When it comes to the ports I usually set up a port range of 100 ports, between 5000 to 5100. There are a few more changes you need to do, here is the walk-through (there is a link at the bottom where you can download the registry string).
- Open the 32bit registry by hitting start -> run and type “regedt32” (it is very important you store this in the 32bit registry and NOT in the regular “regedit“
- Navigate to “HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Rpc“
- Create a new Key (folder) and name it “Internet“
- In this Key / folder, create the following:
- Create a new “REG_SZ” and name it “PortsInternetAvailable” and add a value equal to “Y“
- Create a new “REG_SZ” and name it “UseInternetPorts” and add a value equal to “Y“
- Create a new “REG_MULTI_SZ” and name it “Ports” here, add the Port range you want, eq. 5000-5100.
When this is done, your registry looks like this:
All the ports you need to open for now is port 135 and port range 5000-5100 (TCP) between the servers.
If you don’t want to type all this you can download the registry file, remember you still have to open regedt32 and choose “Import” from the file menu.