Didn't work too.
I have un-installed the DTC and re-installed. Stopped and restarted it, on both, K2 and DB servers.
HS
Did you make sure that you have all your service objects configured as your source server?
Do you have any screenshot you can share?
Hi Hussian,
Some things you can check or try on:
1. Check that the MSDTC settings on all servers are correct. If the SQL servers are clustered, make sure you configure the cluster MSDTC as well.
2. If the SQL servers are clustered, try setting the MSDTC authentication to "No authentication required" on all servers.
3. If any of the servers has multiple network cards, check the routing tables. Make sure they are running on the internet network that does not pass by any firewalls or have a properly configured firewall that allows MSDTC communications.
4. Use DTCTester or DTCPing to test the connections between the servers.
Good luck!
JK
Hi!
Here are some facts and findings about the testing environment issue I am facing:
1. I am using a development box to deploy the solution. I will call it "Client1".
2. We DO NOT have a clustered DB on the test. Only a virtual SQL server. I will call it "Server1".
3. We have a virtual K2 machine "Server2" and a virtual Sharepoint machine "Server3".
4. There are no firewalls enabled on all the machines above.
5. I ran the DTCping tool on "Server1" and "Server2" and got the below error:
"Server1"
IP Configure Information
Host Name . . . . . . . . . : vm-test-sql64
DNS Servers . . . . . . . . : 10.1.16.34
10.1.16.35
Node Type . . . . . . . . . : Hybrid
NetBIOS Scope ID. . . . . . :
IP Routing Enabled. . . . . : no
WINS Proxy Enabled. . . . . : no
NetBIOS Resolution Uses DNS : no
Ethernet adapter {5E589617-70C4-4CCE-8EAF-113432E3FE20}:
Description . . . . . . . . : Intel(R) PRO/1000 MT Network Connection
Physical Address. . . . . . : 00-0C-29-73-90-EC
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . : 10.1.16.78
Subnet Mask . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . : 10.1.16.254
DHCP Server . . . . . . . . :
Primary WINS Server . . . . :
Secondary WINS Server . . . :
Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970
++++++++++++lmhosts.sam++++++++++++
++++++++++++hosts ++++++++++++
127.0.0.1 localhost
::1 localhost
11-06, 08:01:12.315-->Error(0x424) at clutil.cpp @256
11-06, 08:01:12.336-->-->OpenCluster
11-06, 08:01:12.514-->-->1060(The specified service does not exist as an installed service.)
..........
Problem:fail to invoke remote RPC method
Error(0x6D9) at dtcping.cpp @303
-->RPC pinging exception
-->1753(There are no more endpoints available from the endpoint mapper.)
RPC test failed
"Server2"
IP Configure Information
Host Name . . . . . . . . . : vm-uat-wf
DNS Servers . . . . . . . . : 10.1.16.35
Node Type . . . . . . . . . : Hybrid
NetBIOS Scope ID. . . . . . :
IP Routing Enabled. . . . . : no
WINS Proxy Enabled. . . . . : no
NetBIOS Resolution Uses DNS : no
Ethernet adapter {A5F3563A-7214-4583-890B-7A9BD59A36D4}:
Description . . . . . . . . : Intel(R) PRO/1000 MT Network Connection
Physical Address. . . . . . : 00-0C-29-5C-F1-BA
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . : 10.1.16.31
Subnet Mask . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . : 10.1.16.254
DHCP Server . . . . . . . . :
Primary WINS Server . . . . :
Secondary WINS Server . . . :
Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970
++++++++++++lmhosts.sam++++++++++++
++++++++++++hosts ++++++++++++
127.0.0.1 localhost
::1 localhost
11-06, 08:01:38.383-->Error(0x424) at clutil.cpp @256
11-06, 08:01:38.399-->-->OpenCluster
11-06, 08:01:38.399-->-->1060(The specified service does not exist as an installed service.)
........
Problem:fail to invoke remote RPC method
Error(0x6D9) at dtcping.cpp @303
-->RPC pinging exception
-->1753(There are no more endpoints available from the endpoint mapper.)
RPC test failed
6. Attached is the configuration on MSDTS.
Thanks
HS
Hi HS,
Did some googling and the error message generally points to blocked ports.
1. I know you have turned off the windows firewall, but is there a hidden hardware firewall in between?
2. Can you check your services.msc. See if "Distributed Transaction Controller" is started?
The following article may be useful in troubleshooting your error.
http://support.microsoft.com/kb/306843/en-us
JK
Hi!
I come to know that the DB server got out of ports (due to unknown reasons) , so I had to restart the box.
Thnings are fine now. Thank you all for your hints and help. :)
Cheers.
Hussain