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 "Distributed Transaction Coordinator"
3. Select the "Auto-start service when OS starts", and click "Start"
If that won't work, try
this solution from MS.