By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,363 Members | 2,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,363 IT Pros & Developers. It's quick & easy.

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

P: 18
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
Apr 18 '08 #1
Share this Question
Share on Google+
1 Reply


P: 92
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.
Apr 21 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.