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 BanningPlease check out Q329332 for help.
Sarah
Showing posts with label pages. Show all posts
Showing posts with label pages. Show all posts
Subscribe to:
Comments (Atom)