MSDTC config for transfaction scope?

[Billy Zhang]

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]]

Hi Billy,

Here're some posts/documentations that may help.

Related posts :
http://forums.asp.net/p/1203072/2581356.aspx
http://sql-server-performance.com/Community/forums/t/5844.aspx

Troubleshooting Problems with MSDTC:
http://msdn.microsoft.com/en-us/library/aa561924.aspx

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:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#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/default.aspx?target=assistance&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+mtTQLCb7HR1X7Du6w==
| From: =?Utf-8?B?QmlsbHkgWmhhbmc=?= <[email protected]>
| Subject: MSDTC config for transfaction scope?
| Date: Mon, 13 Oct 2008 03:19:01 -0700
| Lines: 9
| Message-ID: <[email protected]>
| 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.public.dotnet.framework.aspnet
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl
microsoft.public.dotnet.framework.aspnet:77767
| NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.public.dotnet.framework.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
|

 

[Billy Zhang]

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]]

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):
http://forums.asp.net/p/1203072/2581356.aspx

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\system32\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 TransactionScope.

Regards,
Allen Chen
Microsoft Online Support

--------------------
| Thread-Topic: MSDTC config for transfaction scope?
| thread-index: AcktHRy0kt7S+mtTQLCb7HR1X7Du6w==
| From: =?Utf-8?B?QmlsbHkgWmhhbmc=?= <[email protected]>
| Subject: MSDTC config for transfaction scope?
| Date: Mon, 13 Oct 2008 03:19:01 -0700
| Lines: 9
| Message-ID: <[email protected]>
| 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.public.dotnet.framework.aspnet
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl
microsoft.public.dotnet.framework.aspnet:77767
| NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.public.dotnet.framework.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]]

Hi Billy,

Have you solved this issue?

Regards,
Allen Chen
Microsoft Online Support
--------------------
| Thread-Topic: MSDTC config for transfaction scope?
| thread-index: AcktHRy0kt7S+mtTQLCb7HR1X7Du6w==
| From: =?Utf-8?B?QmlsbHkgWmhhbmc=?= <[email protected]>
| Subject: MSDTC config for transfaction scope?
| Date: Mon, 13 Oct 2008 03:19:01 -0700
| Lines: 9
| Message-ID: <[email protected]>
| 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.public.dotnet.framework.aspnet
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl
microsoft.public.dotnet.framework.aspnet:77767
| NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.public.dotnet.framework.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
|

 

[Billy Zhang]

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