Hall of Fame

1. johnb6767178,417
2. nobus172,892
3. LeeTutor123,516
4. dstewartjr120,282
5. oBdA93,696
6. flubbster61,860
7. BillDL53,310
8. Merete52,363
9. demazter52,286
10. leew50,644
11. dbrunton48,999
12. torimar47,585
13. rindi47,245
14. Qlemo45,911
15. tigermatt44,719
16. Computer...41,190
17. andrew_...39,787
18. jcimarron39,654
19. Shift-338,602
20. thinkpads...32,739
21. arnold32,595
22. MASQUE...31,301
23. Chris-Dent31,290
24. houssam...30,625
25. SysExpert27,544

1. LeeTutor550,527
2. johnb6767525,196
3. nobus484,500
4. KCTS430,309
5. and235...298,068
6. leew236,418
7. sirbounty229,794
8. SysExpert207,041
9. oBdA204,500
10. rindi203,633
11. Sheharya...192,296
12. war1188,129
13. PUNKY174,021
14. orangutang171,954
15. tigermatt171,291
16. Merete167,609
17. Shift-3160,181
18. michko159,546
19. MrHusy154,737
20. rpggamer...145,022
21. willcomp135,888
22. dstewartjr130,592
23. jkr121,592
24. RobWill118,258
25. younghv116,163

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.2

MSDTC not working

Asked by kesea in Microsoft Windows Operating Systems, Windows XP Operating System

Tags: Microsoft, Windows XP, Serivce Pack 2, MSDTC

I have installed MSDTC on a laptop here at work and it will not communicate with my SQL server. I have tried everything to get it working. Is there a way I can debug my MSDTC? The service is running, and I have tried everything related to MSDTC on Google. I just need to know how can I get message from MSDTC, I have tried turning off the firewall, leaving the firewall on and adding the ports to it. It just seems like something is prevent the MSDTC transaction from coming back into the computer. I think it can go out. I ran the dtctester and got this message:

C:\temp>dtctester sp3d sa sund3r
Executed: dtctester
DSN: sp3d
User Name: sa
Password: sund3r
tablename= #dtc586
Creating Temp Table for Testing: #dtc586
Warning: No Columns in Result Set From Executing: 'create table #dtc586 (ival int)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=25S12,Native error=-2147168220,msg='[Microsoft][ODBC SQL Server Driver]
Distributed transaction error'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid cursor state

Typical Errors in DTC Output When
a. Firewall Has Ports Closed
-OR-
b. Bad WINS/DNS entries
-OR-
c. Misconfigured network
-OR-
d. Misconfigured SQL Server machine that has multiple netcards. Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.

I know there is nothing wrong with the server because it works fine on my XP desktop, it is just this new dell XP laptop I just got.

View the Solution FREE for 30 Days

	Title
1	MSDTC Errors - SQLSTATE=3700…
2	DTCTester error, can anyone help

MSDTC not working

Asked by kesea in Microsoft Windows Operating Systems, Windows XP Operating System

Tags: Microsoft, Windows XP, Serivce Pack 2, MSDTC

About this solution