http://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/8501.aspxThu, 18 Nov 2010 06:10:58 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8501neo0http://sqlserver.ro/forums/thread/8501.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8501firewall-ul era pe disable....telnet-ul pe portul 135 merge..Am doar un firewall fizic care o data ce merge telnet-ul pe 135 intre servere nici el inseamna ca nu blocheaza. Insa este adevarata afirmatia... <br /> <br />"MSDTC response messages return on a dynamically assigned port anywhere in a range from 1024 – 5000." ??? (http://decipherinfosys.wordpress.com/2007/03/08/network-port-configurations-for-msdtc/) acest range de porturi trebuie sa fie liber?? <br /> <br /> <br />Multumesc.http://sqlserver.ro/forums/thread/8499.aspxWed, 17 Nov 2010 21:09:41 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8499B_gd_n[ ]Sahlean0http://sqlserver.ro/forums/thread/8499.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8499[1] Verificați setările firewall pentru cele două servere.<br>[2] <a href="http://support.microsoft.com/kb/306212">http://support.microsoft.com/kb/306212</a><br>http://sqlserver.ro/forums/thread/8495.aspxTue, 16 Nov 2010 11:43:28 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8495neo0http://sqlserver.ro/forums/thread/8495.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8495salut, am si eu urmatoarea problema: <br /> <br />Se dau 2 instante: una SQL 2008 R2 (win 2008) si alta SQL Server 2005 SP1 (win 2003) in domenii diferite, desi am configurat corect DNS-ul pe fiecare dintre servere, cat si MSDTC-ul pentru tranzactii distribuite (cu account-ul NT Autority\Network Service), un statement de genul: <br /> <br />begin tran <br /> set xact_abort on <br /> update linkServer.db.dbo.tabel where.. <br />commit tran <br /> <br />nu functioneaza... <br /> <br /> <br />eroarea <br />"Msg 7391, Level 16, State 2, Line 4 <br />The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "BDBSRV02\SEC" was unable to begin a distributed transaction. <br />" <br />(banuiesc ca nu se autentifica intre ele cele 2 MSDTS-uri: unul dintre SO-uri este win 2003 si celalalt 2008) <br /> <br />Multumesc.