468,296 Members | 1,270 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,296 developers. It's quick & easy.

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

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
1 1028
deric
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.

Similar topics

5 posts views Thread by Mike Owen | last post: by
5 posts views Thread by Loane Sharp | last post: by
reply views Thread by Selvakumar, Information Dynamics | last post: by
1 post views Thread by HandersonVA | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.