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.