Re: Problem with SQL Server & MSDTC on Windows 2003 (dtctester.exe related)
From: Dave Verwer (d.verwer_at_link-hrsystems.com)
Date: 03/12/04
- Next message: john gibbons: "Re: removal of service pack 4"
- Previous message: Kevin: "Licensing"
- In reply to: Dave Verwer: "Problem with SQL Server & MSDTC on Windows 2003 (dtctester.exe related)"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 12 Mar 2004 17:08:02 -0000
Additional Information which I forgot to add in the original post.
In response to the suggestions the dtctester app gives me:
a. Firewall Has Ports Closed
- There is no firewall in between the two machines
b. Bad WINS/DNS entries
- These are fine and checked
c. Misconfigured network
- I can communicate with the server over everything apart from DTC
transactions
d. Misconfigured SQL Server machine that has multiple netcards.
- This is too vague to really know what they mean but I have disabled every
other network card in the machine so there is only one active local
connection.
"Dave Verwer" <d.verwer@link-hrsystems.com> wrote in message
news:ObEBOsECEHA.684@tk2msftngp13.phx.gbl...
> Hi all
>
> I am not sure if this is a Windows 2003 server problem or a SQL Server
> problem so I am cross posting to both groups.
>
> I have a new Dell server which is running Windows 2003 and is going to be
a
> development database server. I have SQL Server 2000 installed on it and i
> can connect using the SQL client tools manipulate data on that server
> without any problems.
>
> The problem comes when I try and connect using an ODBC connection from
> within an MTS/COM+ component. I get the following error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '8004d00a'
> [Microsoft][ODBC SQL Server Driver]Distributed transaction error
>
> While searching for a solution to this problem, I came across a Microsoft
> utility (available from
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q293799) which has
> helped me narrow this problem down to it not being my COM+ component
because
> when I try and run this tool I get the following output:
>
> Executed: dtctester
> DSN: <My DSN Name>
> User Name: sa
> Password: <My sa Password>
> tablename= #dtc32294
> Creating Temp Table for Testing: #dtc32294
> Warning: No Columns in Result Set From Executing: 'create table #dtc32294
> (ival int)'
> Initializing DTC
> Beginning DTC Transaction
> Enlisting Connection in Transaction
> Error:
> SQLSTATE=25S12,Native error=-2147168219,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.
>
> My feeling is that it is specific to Windows 2003 because I can perform
> exactly the same test using dtctester.exe to our old SQL server from the
> same client and using the same ODBC DSN (with the server name changed of
> course) and everything works without problems.
>
> Thanks in advance for any help you can give,
>
> Dave
>
>
- Next message: john gibbons: "Re: removal of service pack 4"
- Previous message: Kevin: "Licensing"
- In reply to: Dave Verwer: "Problem with SQL Server & MSDTC on Windows 2003 (dtctester.exe related)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
