473,883 Members | 1,603 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MSDTC config for transfaction scope?

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
Oct 13 '08 #1
5 2019
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/Co...ms/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:
ms****@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=?= <ht****@noemail .noemail>
| Subject: MSDTC config for transfaction scope?
| Date: Mon, 13 Oct 2008 03:19:01 -0700
| Lines: 9
| Message-ID: <7B************ *************** *******@microso ft.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
|

Oct 14 '08 #2
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 :
http://forums.asp.net/p/1203072/2581356.aspx
http://sql-server-performance.com/Co...ms/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:
ms****@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=?= <ht****@noemail .noemail>
| Subject: MSDTC config for transfaction scope?
| Date: Mon, 13 Oct 2008 03:19:01 -0700
| Lines: 9
| Message-ID: <7B************ *************** *******@microso ft.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
|

Oct 14 '08 #3
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\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=?= <ht****@noemail .noemail>
| Subject: MSDTC config for transfaction scope?
| Date: Mon, 13 Oct 2008 03:19:01 -0700
| Lines: 9
| Message-ID: <7B************ *************** *******@microso ft.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
|

Oct 14 '08 #4
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=?= <ht****@noemail .noemail>
| Subject: MSDTC config for transfaction scope?
| Date: Mon, 13 Oct 2008 03:19:01 -0700
| Lines: 9
| Message-ID: <7B************ *************** *******@microso ft.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
|

Oct 17 '08 #5
Thank you!
It worked fine after I restarted the DB server.

"Allen Chen [MSFT]" wrote:
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=?= <ht****@noemail .noemail>
| Subject: MSDTC config for transfaction scope?
| Date: Mon, 13 Oct 2008 03:19:01 -0700
| Lines: 9
| Message-ID: <7B************ *************** *******@microso ft.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
|

Oct 17 '08 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
8193
by: KO | last post by:
SQL Server Enterprise Manager could not start the service 'MSDTC' on server 'NTAS21'. 1722 - (The RPC server is unavailable) I Setup A publication on a server called NTAS4D, then Pushed The Subscription to another server called NTAS21. If I configure so that the changes at the subscriber are not replicated to the publisher, all works ok, I make a change at the publisher, it is replicated to the subscriber.
0
3743
by: Gary | last post by:
All, I am experiencing an error using MSDTC with SQL Server 2000 on Windows 2003 server. The code in question is a stored procedure that does a query within a transaction using linked servers. The code worked perfectly well on NT 4 w/ SQL Server 2000. Running the same code on Windows 2003 produces the following error: The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed...
1
1824
by: JIMMIE WHITAKER | last post by:
I'm using msde. On the little icon in task tray, you have under current service, a choice of mssqlserver, and another choice is msdtc. What is msdtc? And what is sqlserver agent?
1
2195
by: MarcoB | last post by:
I am trying to use Microsoft Distributed Processing and I am getting the following error. "There is no MTS objectcontext " I have SQL MSDTC loaded on my PC. I have added the code below: Any ideas ?? Tks. ------------------------------------ Imports System.EnterpriseServices
1
2206
by: sjoshi | last post by:
Hello I had a question reagrding MSDTC usage. I know that MSDTC will enlist each connection transactions as it's own (take ownership) and commit/abort accordingly. However I'm not sure what would happen where I have a stored proc with input parameters and 2 Delete commands on 2 different tables. In this case, would MSDTC also enforce ACID rules when 1 cmd succeeds and 2nd aborts ? In the script for the Stored Proc, there is no checking...
3
2937
by: =?Utf-8?B?YWJheWVy?= | last post by:
In short: I have an application using the CommittableTransaction class that works fine when run locally, but does not escalate to MSDTC when deployed to a Windows 2003 R2 server. More Specifically: I have a web service that saves data to a database. This service uses a CommittableTransaction to decide when to Commit or Abort the underlying
6
3052
by: =?Utf-8?B?ZXhl?= | last post by:
Hi, I'm using TransactionScope to do a serie Insert, Update, Delete operations with the ExecuteNonQuery and some Selects with ExecuteScalar everything works fine with multiple connections in the same scope. Problem is that when i do two Selects with ExecuteReader (to fill datasets) it shows the folowing error: Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the...
6
2015
by: =?Utf-8?B?UGF1bCBQcmV3ZXR0?= | last post by:
Hi - I have 4 webservers in my webfarm. All Win2k3 web edition. Before yesterday, none of them were service packed. I have now applied SP2 to two of them, and I'm getting a very weird MSDTC error on them now. The error occurs when I attempt a series of SQL statements wrapped in a TransactionScope(). It's executing against a different server, so this is where it's elevated to a distributed transaction.
1
2174
by: =?Utf-8?B?QmlsbHkgWmhhbmc=?= | last post by:
I have a web server 32 bit and SQL server 2005 64bit . Does msdtc support SQL server 2005 64bit with web server 32 bit?
0
9942
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10749
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10857
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9577
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7974
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5801
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5994
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4618
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3236
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.