September 21, 2007 at 2:13 am
Hi All,
This is my first post so sorry for being a complete newbie.
I am have a real problem setting up MSDTC. We are running Windows 2003 with SQL version 8 SP4. I have followed everything in the following links:
Enable MSDTC (disabled by default)
- Reinstalling MSDTC
- Running "netsh ...etc" to enable the port (I also have disabled the firewall at all).
- Change some registry keys (also configurable from Component Services)
- Turned off RPC Security key on the registry
- The user for MSDTC is NTAuthority\NetworkService.
- In the configuration tab, Enabled almost anything.
I have not installed the - Install the MSDTC Hotfix Rollup 6, is this needed?
When I run dtctester I get the following:
C:\Documents and Settings\Administrator.OFFICE>"D:\Archive\_downloads\dtctest\dt
ctester.exe" sql01 **** *****
Executed: D:\Archive\_downloads\dtctest\dtctester.exe
DSN: sql01
User Name: *****
Password: ******
tablename= #dtc20345
Creating Temp Table for Testing: #dtc20345
Warning: No Columns in Result Set From Executing: 'create table #dtc20345 (ival
int)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server Driver]
Distributed transaction error'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid cur
sor state
Typical Errors in DTC Output When
a. Firewall Has Ports Closed
-OR-
b. Bad WINS/DNS entries
-OR-
c. Misconfigured network
-OR-
d. Misconfigured SQL Server machine that has multiple netcards.
Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.
I am really pulling my hair out (well what I have left), please help.
Thanks
Barry
September 21, 2007 at 12:43 pm
Is the other side also windows 2003?
Is there a firewall in between?
This post mentions also another utility dtcping
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=455113&SiteID=1
just for future reference
dtstester: http://support.microsoft.com/kb/293799
October 12, 2007 at 3:30 am
Hi
Sorry been away on holiday.
Yes the other side is also Windows 2003.
Yes there are 2 firewalls, but they are setup so that its totaly open between them.
Tried dtcping, I get the following:
External Server Response:
DTCping log file: ****
RPC server is ready
Please Start Partner DTCping before pinging
Please send following LOG to Microsoft for analysis:
Partner LOG: ****.log
My LOG: ****.log
++++++++++++Validating Remote Computer Name++++++++++++
Please refer to following log file for details:
C:\Downloads\****.log
Invoking RPC method on eonicprod01
Problem:fail to invoke remote RPC method
Error(0x6BA) at dtcping.cpp @303
-->RPC pinging exception
-->1722(The RPC server is unavailable.)
RPC test failed
Internal Machine response:
DTCping log file: ****.log
Firewall Port Settings:
Port:1024-3372
RPC server is ready
Please Start Partner DTCping before pinging
++++++++++++Validating Remote Computer Name++++++++++++
Please refer to following log file for details:
****.log
Invoking RPC method on ****
RPC test is successful
++++++++++++RPC test completed+++++++++++++++
Please start PING from **** to complete the test
Also tried dtctester, I get the following:
Executed: d:/archive/_downloads/dtctest/dtctester.exe
DSN: *****
User Name: *****
Password: *****
tablename= #dtc9382
Creating Temp Table for Testing: #dtc9382
Warning: No Columns in Result Set From Executing: 'create table #dtc9382 (ival i
nt)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server Driver]
Distributed transaction error'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid cur
sor state
Typical Errors in DTC Output When
a. Firewall Has Ports Closed
-OR-
b. Bad WINS/DNS entries
-OR-
c. Misconfigured network
-OR-
d. Misconfigured SQL Server machine that has multiple netcards.
Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.
Did you want me to put the Log files up?
October 12, 2007 at 7:24 am
I have been through the complete Microsoft support centre and done everything that is says and it is still not working.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply