Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: DTC Problems on SQL 2000/Windows Server 2003

    I have an ASP application that is working on IIS 4.0/NT 4.0 and SQL Server 7.0/NT 4.0. The ASP pages are using a package registered in the MTS 2.0 running on the IIS server.

    I am starting to move my databases over to a new server running SQL Server 2000 on Windows Server 2003.

    When I change the database server name in the connection string on the ASP pages and then attempt to run that page I get:

    Microsoft OLE DB Provider for SQL Server error '8004d00a'

    New transaction cannot enlist in the specified transaction coordinator.

    I have confirmed that the Distributed Transaction Controller is running on my new SQL Server box and I have confirmed that network DTC access is on. If I stop the DTC service on my new SQL Server, the error message indicates that the DTC is not running.

    Now I am stuck. Any ideas would be greatly appreciated.

    Jeff Banning

  2. #2
    Join Date
    Apr 2002
    Please check out Q329332 for help.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts