| Bonson Mampilli 2006-11-30, 7:14 pm |
| Hi,
I have 2 servers.
Server 1
This is running Windows Server 2000 sp3. I have an application installed on
this system that needs to talk to the SQL server.
Server 2
This is running on Windows server 2003 r2. This machine contains the SQL
Server database is 2000.
For my application to be able to talk the database, the pre-requisite is
that DTC should function properly.
However, when we run DTCTester utility from the Server1, it goes into a hang
without giving any error after printing the following lines:
Command Line: dtctester bad baduser badpass
Executed: dtctester
DSN: bad
User Name: baduser
Password: badpass
tablename=#dtc7421
Creating Temp Table for Testing: #dtc7421
Warning: No Columns in Result Set From Executing: 'create table #dtc7421
(ival int)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
The actual result that should be displayed is given on the following page:
http://support.microsoft.com/kb/293799
Any help would be appreciated.
Regards,
Bonson Mampilli
|