Fix "New transaction cannot enlist in the specified transaction coordinator" on Server 2003 SP2 Fix "Novi posel ne more vpoklicati v določenem koordinator transakcija" na Server 2003 SP2

If you are running a web application using the original ASP technology on Windows Server 2003, you might get this error message once you upgrade to Service Pack 2: “New transaction cannot enlist in the specified transaction coordinator. Če uporabljate spletne aplikacije z uporabo prvotne tehnologije ASP na Windows Server 2003, lahko dobiš to sporočilo o napaki, ko nadgradite na Service Pack 2: "Novi posel ne more vpoklicati v določenem koordinatorja transakcijo. [-2147168246]“. [-2147168246] ".

The cause for this error is that MSDTC has a setting that requires authentication for distributed transactions, and the upgrade to SP2 might change the setting to required instead of none. Vzrok za to napako je, da MSDTC je nastavitev, ki zahteva preverjanje pristnosti za porazdeljene transakcije, ter nadgradnjo na SP2 se lahko spremeni nastavitev, da zahteva namesto nič.

To fix this error, open Component Services and right-click on the My Computer icon and choose properties. Če želite popraviti to napako, odprite Component Services in desno-kliknite na ikono Moj računalnik in izberite lastnosti.

Choose the MSDTC tab and then at the bottom of the window click the Security Configuration button. Izberite jeziček MSDTC in nato na spodnjem delu okna kliknite gumb Security Configuration.

In this window, change the setting under Transaction Manager Communication to “No Authentication Required”. V tem oknu, spremenite nastavitev na podlagi Transaction Manager sporočilo "No Authentication Required".

This should resolve this error. To bi moralo odpraviti to napako.

Note that if you have a firewall between the web server and database server then you should ensure that high ports are open between the two machines, along with RPC, as that could also cause the same error. Upoštevajte, da če imate požarni zid med spletni strežnik in strežnik zbirke podatkov potem morate zagotoviti, da so visoke pristanišč, odprtih med dvema stroji, skupaj z RPC, kot da lahko povzroči tudi isto napako.

| | More Več

This article was originally written on 06/2/07 Tagged with: Ta članek je bil prvotno napisan na 06/2/07 Tagged with: Windows Windows

Daily Email Updates Dnevni Email Updates

You can get our how-to articles in your inbox each day for free. Lahko dobite našo kako do člankov v vašo mapo »Prejeto vsak dan brezplačno. Just enter your name and email below: Preprosto vpišite vaše ime in e-pošto spodaj:

Name: Ime:
Email: E-pošta:

Similar Articles Podobni členi	Tinyhacker - Tiny Geek Hacks Tinyhacker - Tiny Geek Hacks
How to Remote Desktop to the Actual Server Console on Windows 2003 Kako Remote Desktop Dejanski konzole v operacijskem sistemu Windows Server 2003 Force Terminal Services Clients to Disconnect when Idle Force Terminal Services Kupci na Disconnect, ko Idle Setup OpenSSH Server on Ubuntu Linux OpenSSH Server Setup na Ubuntu Linux Make Word 2007 Always Save in Word 2003 Format Make Word 2007 Vedno Shrani v Word 2003 format Encrypt Traffic Between Outlook and Exchange Encrypt prometa med Outlook in Exchange	60 Mindblowing Panorama and Vertorama Pictures 60 Mindblowing Panorama in Vertorama Slike Paranoid about Security? Paranoid o varnosti? Learn How to Detect Keyloggers Več o tem, kako zaznati Keyloggers Running Your Own Business? Running Your Own Business? Make Sure You Have the Freelancer's Toolset Preverite, ali ste Freelancer's komplet StillTasty Tells You When to Throw Out the Milk StillTasty vam pove Kdaj Vrzi Out Milk Machinarium is a Beautiful, Artsy Flash Puzzle Game Machinarium je lep, Artsy Flash Puzzle Game Figure Out What Those Internet Acronyms Mean Slika, kaj Ti Internet Acronyms Mean
Latest Software Reviews Zadnji Software Reviews	Super User Daily Super User Daily
PCmover Professional PCmover Professional Spyware Doctor + Antivirus 2010 Spyware Doctor + Antivirus 2010 Cakewalk Guitar Tracks Pro USB Prosto kot pasulj Guitar Tracks Pro USB BitDefender Total Security 2010 BitDefender Total Security 2010	how to enable 3d cube in ubuntu 9.10 kako omogočiti 3d kocko v ubuntu 9,10 In unices, do new folders/files inherit parent permissions? V unices, do nove mape / files dedujejo dovoljenja staršev? Windows 7 installation reboot loop Windows 7 namestitev odmevajoč zanka Is there a free utility for creating cross references list for php like this ? Ali obstaja brezplačno orodje za ustvarjanje seznama za sklicevanje php, kot je ta?
Geek Arcade Geek Arcade	Popular Forum Threads Forum Popular Threads
Open Doors Odprta vrata Boombot Boombot Demolition City Rušenje City Heavy Weapons Heavy Weapons	How do I flush my RAM? Kako sem izpirajte moje RAM? replacing a psu nadomešča psu Preview Windows 7 Predogled Windows 7 Windows Vista User Account Control (UAC) - Why it's useful Windows Vista User Account Control (UAC) - zakaj je koristno

Comments (12) Komentarji (12)

1. August 22, 2007 5:29 pm 22. avgust 2007 5:29
   adamm adamm

   Thanks for publishing this article. Hvala za objavo tega članka. Looks like it has fixed an issue we've had with our production server for 3 weeks now! Izgleda, da je določena vprašanja smo imeli z našo proizvodnjo strežnik za 3 tedne zdaj!

2. October 23, 2007 4:25 am 23. oktober 2007 4:25
   Øyvind Øyvind

   Thanks a lot! Hvala veliko! This fixed our problem right away. Ta fiksna naš problem takoj.

3. January 10, 2008 2:55 am 10. januar 2008 2:55
   In hyderabad In Hyderabad

   Hi, Živjo,

   I have the same problem, but it is with a win 2K Server, and it seems the 2K server does not have the security settings that you mentioned. Imam isto naloga, vendar je z zmago 2K Server, in zdi se, 2K strežnik nima varnostne nastavitve, ki ste ga omenili. So what could be wrong with the 2k server. Torej, kaj bi bilo lahko narobe s strežnikom 2k. Things were working fine till a few weeks back, but all of a sudden we started getting this error for some of the COM components. Stvari so dela lep do nekaj tednov nazaj, ampak vse naenkrat se je začela ta napaka za nekatere komponente COM.

4. April 9, 2008 12:30 am 9. april 2008 12:30
   Mikael Sand Mikael Sand

   Hellooooo! Hellooooo! Anyone actually stopped to think as to WHY the base setting is Athentication Required? Kdor je dejansko ustavil, da razmišljajo, zakaj osnovno nastavitev je Athentication Required? Mabye that is a good idea? Mabye, da je dobra ideja? Maybe you shouldn't just turn it off. Mogoče bi morali ne samo izklopite.

   That is all To je vse

5. April 22, 2008 3:44 am 22. april 2008 3:44
   Viswanath Viswanath

   Really good article Res dober članek

6. May 28, 2008 8:05 am 28. maj 2008 8:05
   Sean Sean

   It worked. Delovalo je. Thank you! Hvala!

7. November 19, 2008 5:21 am 19. november 2008 5:21
   vivek soni Vivek Soni

   Hi, Živjo,

   I m facing same problem with differant senerio Jaz sem se soočajo z isto težavo differant senerio
   using OS —- wondows 2000 professional (This property dialog box not appears in my Os) z OS - wondows 2000 poklicnih (Ta lastnost pogovorno okno ne pojavi v mojem Os)

   SQL SERVER 2000— both databases on same machine SQL Server 2000 - obeh podatkovnih baz na istem stroju

   please help me out prosim pomoč mi jasno

   Thanks Hvala

8. March 29, 2009 4:38 pm 29. marec 2009 4:38
   Rob Sukach Rob Sukach

   Thanks – exactly what I needed! Hvala - točno to, kar sem potreboval!

9. July 10, 2009 1:26 am 10. julij 2009 1:26
   Andre Andre

   Hi, I get the same error message on a windows 2008 box with SQL 2005 when I want to insert data in a oracle database through a transaction. Živjo, jaz zaslužiti isto sporočilo o napaki na okno 2008 okno z SQL 2005, ko hočem vstaviti podatkov v Oracle Database s transakcijo.
   There is a firewall between the two systems, so I think it is nescesarry to open ports on te firewall, but it is not allowed to open a lot of ports. Obstaja požarni zid med dvema sistemoma, zato menim, da je nescesarry, da odprete vrata za te požarni zid, vendar ne sme odpreti veliko pristanišč. Can you tell me wich ports i need to open in the firewall? Mi lahko poveste, katera pristanišča rabim odpreti v požarni zid?

   Kind regards, Kind regards,

   André André

10. September 3, 2009 8:15 am 3. september 2009 8:15
    mss MSS

    hi, živjo,

    I in my system i have only installed the SQL client, and i am sharing SQL server from my colleages system. I v svoj sistem imam le umestiti SQL stranko, in jaz sem izmenjavo SQL strežnik iz moje kolege sistem. i am also facing “New transaction cannot enlist in the specified transaction coordinator” error. jaz sem tudi, s katerimi se sooča "Novi posel ne more vpoklicati v določenem koordinator posla" napaka. i tried above option but its not working for me could you please help me out. si se potrudil zgoraj možnost šele svoj ne delajo za mene lahko vi prosim pomoč mi jasno.

11. October 13, 2009 5:15 am 13. oktober 2009 5:15
    Lian Lian

    Good Day, Dober dan,
    I experienced the same problem . Sem doživel isto težavo. I made the changes as suggested, but alas, this did not solve my problem. Naredil sem spremembe, kot je predlagano, ampak žal, to ni moj problem rešiti. Any ideas what to do next ? Vse ideje, kaj storiti naslednje?

12. November 9, 2009 10:07 pm 9. november 2009 10:07
    anamika anamika

    Hi, Živjo,

    The article was so useful. Članek je bil tako koristen.
    it resolved my problem. to rešiti moj problem. It helped in a crucial situation. Pomagal je v ključni situaciji.

    Thanks, Hvala,
    anamika anamika