"New transaction cannot enlist in the specified transaction coordinator" Error When Using COM+ on Win 2003
Posted on 2007-10-18
I'm getting an error when running some simple VB6 code that accesses a COM+ application which attempts to connect to SQL 2000. The error is...
"New transaction cannot enlist in the specified transaction coordinator."
The error occurs on the ADODB.Connection open statement.
In the event log, I get the following:
Event Type: Failure Audit
Event Source: Security
Event Category: Logon/Logoff
Event Id: 529
User: NT Authority\System
Reason: Unknown user name or password
where xxxxx is the name of the sql server to which I'm trying to connect.
The simple test application is VB6 and COM+. The COM+ piece was written in version 1.0 and loaded in COM+ 2.0 under Win 2003. The application is running under Win 2003 std SP2, NTLMV2 only.
I'm using MS DTC, DCOM to DCOM. DTC service is turned on for both servers. The target server is a Win 2003 server with SQL 2000 sp3a.
This works fine on Windows 2000.
Can you please offer any advise?