My ASP application is not working when i moved from sql server 2000 to 2005

[Saray]

Hi

I deployed my ASP web application with the backend sql server 2000.Now i would like to change from sql serer 2000 to 2005 64 bit machine.

its giving some error like

New transaction cannot enlist in the specified transaction coordinator.


Please advice me.
Thanks in advance

Saray

[deric]

Hi

I deployed my ASP web application with the backend sql server 2000.Now i would like to change from sql serer 2000 to 2005 64 bit machine.

its giving some error like

New transaction cannot enlist in the specified transaction coordinator.


Please advice me.
Thanks in advance

Saray

If you just first search for that error message on the net, you would find several discussions and solutions about it thus saving you time.

Most of the time, it is caused when you try to start distributed transaction between 2 servers while the MS DTC is not running. Try to do the following:
1. Open the SQL Server Service Manager
2. On the "Services" dropdown list, select "Distribute d Transaction Coordinator"
3. Select the "Auto-start service when OS starts", and click "Start"

If that won't work, try this solution from MS.