MSDTC config for transfaction scope?

**Allen Chen [MSFT]** · Oct 14 '08, 02:15 AM

RE: MSDTC config for transfaction scope?

Hi Billy,

Here're some posts/documentations that may help.

Related posts :

http://forums.asp.net/p/1203072/2581356.aspx

A broad category of Microsoft tools, languages, and frameworks for software development. Designed to support developers in building, debugging, and deploying applications across various platforms.

The resource cannot be found.

http://sql-server-performance.com/Community/forums/t/5844.aspx

Troubleshooting Problems with MSDTC:

Troubleshooting Problems with MSDTC - BizTalk Server

http://msdn.microsoft.com/en-us/library/aa561924.aspx

Learn more about: Troubleshooting Problems with MSDTC

Please feel free to let me know if you need further assistance.

Regards,
Allen Chen
Microsoft Online Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@microsof t.com.

=============== =============== =============== =====
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subs...#notifications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://support.microsoft.com/select/...tance&ln=en-us.
=============== =============== =============== =====
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Thread-Topic: MSDTC config for transfaction scope?
| thread-index: AcktHRy0kt7S+mt TQLCb7HR1X7Du6w ==
| From: =?Utf-8?B?QmlsbHkgWmh hbmc=?= <htinns@noemail .noemail>
| Subject: MSDTC config for transfaction scope?
| Date: Mon, 13 Oct 2008 03:19:01 -0700
| Lines: 9
| Message-ID: <7B6E0CEA-C9B2-42F5-A4B9-6D5D6736DFAF@mi crosoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.3119
| Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
| Path: TK2MSFTNGHUB02. phx.gbl
| Xref: TK2MSFTNGHUB02. phx.gbl
microsoft.publi c.dotnet.framew ork.aspnet:7776 7
| NNTP-Posting-Host: tk2msftibfm01.p hx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.aspnet
|
| I have two web server, one DB server with two Database. I used MS
enterprise
| transaction with transfaction scope.
|
| How to config MSDTC between the web server and DB to make it work?
|
| any document?
|
| Thanks,
| -Billy
|

**=?Utf-8?B?QmlsbHkgWmhhbmc=?=** · Oct 14 '08, 06:55 AM

RE: MSDTC config for transfaction scope?

I will try your suggestions.

another question:

I have a web server 32 bit and SQL server 2005 64bit .
Does msdtc support SQL server 2005 64bit with web server 32 bit?

Thanks,
-Billy

"Allen Chen [MSFT]" wrote:

Hi Billy,
>
Here're some posts/documentations that may help.
>
Related posts :

Developer technologies - Microsoft Q&A

http://forums.asp.net/p/1203072/2581356.aspx

A broad category of Microsoft tools, languages, and frameworks for software development. Designed to support developers in building, debugging, and deploying applications across various platforms.

The resource cannot be found.

http://sql-server-performance.com/Community/forums/t/5844.aspx

>
Troubleshooting Problems with MSDTC:

Troubleshooting Problems with MSDTC - BizTalk Server

http://msdn.microsoft.com/en-us/library/aa561924.aspx

Learn more about: Troubleshooting Problems with MSDTC

>
Please feel free to let me know if you need further assistance.
>
Regards,
Allen Chen
Microsoft Online Support
>
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@microsof t.com.
>
=============== =============== =============== =====
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subs...#notifications.
>
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://support.microsoft.com/select/...tance&ln=en-us.
=============== =============== =============== =====
This posting is provided "AS IS" with no warranties, and confers no rights.
>
--------------------
| Thread-Topic: MSDTC config for transfaction scope?
| thread-index: AcktHRy0kt7S+mt TQLCb7HR1X7Du6w ==
| From: =?Utf-8?B?QmlsbHkgWmh hbmc=?= <htinns@noemail .noemail>
| Subject: MSDTC config for transfaction scope?
| Date: Mon, 13 Oct 2008 03:19:01 -0700
| Lines: 9
| Message-ID: <7B6E0CEA-C9B2-42F5-A4B9-6D5D6736DFAF@mi crosoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.3119
| Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
| Path: TK2MSFTNGHUB02. phx.gbl
| Xref: TK2MSFTNGHUB02. phx.gbl
microsoft.publi c.dotnet.framew ork.aspnet:7776 7
| NNTP-Posting-Host: tk2msftibfm01.p hx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.aspnet
|
| I have two web server, one DB server with two Database. I used MS
enterprise
| transaction with transfaction scope.
|
| How to config MSDTC between the web server and DB to make it work?
|
| any document?
|
| Thanks,
| -Billy
|
>
>

**Allen Chen [MSFT]** · Oct 14 '08, 07:05 AM

RE: MSDTC config for transfaction scope?

Hi Billy,

From your another post I know you're using 32bit web server and 64bit DB
server.

I've tested it on my side. It worked fine. I have a 32bit XP SP2 machine as
the web server and a Windows 2003 64bit machine with SQL Server 2005 64bit
installed as a DB server.

Firstly please follow the instructions in this post to configure MSDTC and
make sure Distribute Transaction Coordinator is running on both the web
server and the DB server (note, after setting the configuration, please
restart the two machines):

Developer technologies - Microsoft Q&A

http://forums.asp.net/p/1203072/2581356.aspx

A broad category of Microsoft tools, languages, and frameworks for software development. Designed to support developers in building, debugging, and deploying applications across various platforms.

Secondly, when I tested it I got an exception: Error HRESULT E_FAIL has
been returned from a call to a COM component. This is because that I didn't
add C:\WINDOWS\syst em32\msdtc.exe as an exception of the Windows Firewall
on the two machines. To test, you can turn off the Windows Firewall on the
web server and the DB server.

If it still doesn't work please tell me the error message (if any) and
provide the code how you use the TransactionScop e.

Regards,
Allen Chen
Microsoft Online Support

--------------------
| Thread-Topic: MSDTC config for transfaction scope?
| thread-index: AcktHRy0kt7S+mt TQLCb7HR1X7Du6w ==
| From: =?Utf-8?B?QmlsbHkgWmh hbmc=?= <htinns@noemail .noemail>
| Subject: MSDTC config for transfaction scope?
| Date: Mon, 13 Oct 2008 03:19:01 -0700
| Lines: 9
| Message-ID: <7B6E0CEA-C9B2-42F5-A4B9-6D5D6736DFAF@mi crosoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.3119
| Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
| Path: TK2MSFTNGHUB02. phx.gbl
| Xref: TK2MSFTNGHUB02. phx.gbl
microsoft.publi c.dotnet.framew ork.aspnet:7776 7
| NNTP-Posting-Host: tk2msftibfm01.p hx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.aspnet
|
| I have two web server, one DB server with two Database. I used MS
enterprise
| transaction with transfaction scope.
|
| How to config MSDTC between the web server and DB to make it work?
|
| any document?
|
| Thanks,
| -Billy
|

**Allen Chen [MSFT]** · Oct 17 '08, 01:35 AM

RE: MSDTC config for transfaction scope?

Hi Billy,

Have you solved this issue?

Regards,
Allen Chen
Microsoft Online Support
--------------------
| Thread-Topic: MSDTC config for transfaction scope?
| thread-index: AcktHRy0kt7S+mt TQLCb7HR1X7Du6w ==
| From: =?Utf-8?B?QmlsbHkgWmh hbmc=?= <htinns@noemail .noemail>
| Subject: MSDTC config for transfaction scope?
| Date: Mon, 13 Oct 2008 03:19:01 -0700
| Lines: 9
| Message-ID: <7B6E0CEA-C9B2-42F5-A4B9-6D5D6736DFAF@mi crosoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.3119
| Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
| Path: TK2MSFTNGHUB02. phx.gbl
| Xref: TK2MSFTNGHUB02. phx.gbl
microsoft.publi c.dotnet.framew ork.aspnet:7776 7
| NNTP-Posting-Host: tk2msftibfm01.p hx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.aspnet
|
| I have two web server, one DB server with two Database. I used MS
enterprise
| transaction with transfaction scope.
|
| How to config MSDTC between the web server and DB to make it work?
|
| any document?
|
| Thanks,
| -Billy
|

**=?Utf-8?B?QmlsbHkgWmhhbmc=?=** · Oct 17 '08, 01:45 AM

RE: MSDTC config for transfaction scope?

Thank you!
It worked fine after I restarted the DB server.

"Allen Chen [MSFT]" wrote:

MSDTC config for transfaction scope?

MSDTC config for transfaction scope?

Comment

Comment

Comment

Comment

Comment