473,839 Members | 1,484 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MSDTC error on Windows 2003

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 transaction.

In the past, the only time I've seen this error is when the MSDTC service
was not running on one of the two servers involved in the query. Both
servers have multiple NICs. Running the DTCPING utility, the RPC request was
failing. I then found another utility called DTCTester, which supposedly
returns more accurate error messages.

Among the possible causes are a) a firewall problem, b) a DNS or WINS
problem, or c) a network problem due to multiple NICs. There is no firewall
between the servers in question, and DNS works (each server can ping the
other, and each can be accessed using NET USE to mount a drive). WINS is not
used in this configuration. Finally, the binding order of the NICs is such
that the one enabled is the first in the list.

After disabling all the NICs except for those used for communication between
the 2 servers in question, DTCPing reports success, while DTCTester still
returns the same generic error message. I have also verified that the login
account used for the MSDTC service is correct.

Any advice as to what may be causing this would be greatly appreciated.

Thanks in advance for any advice.

-Gary

Jul 20 '05 #1
0 3742

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

Similar topics

4
3686
by: indushekara | last post by:
HI, I am getting an error on my sqlserver database server. My clients are getting kicked out of transaction, giving an error "New transaction cannot enlist in the specified transaction coordinator" When i saw the event log on the DB server i found the following message ************************************ Event Type: Information
6
13974
by: cylt | last post by:
Hello, I'm using a TransactionScope with a ADO.NET SqlClient and i get the error : System.Runtime.InteropServices.COMException (0x8004D024): The transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D024). Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool. I've checked the configuration on both the client...
1
2203
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...
0
2559
by: hafeez | last post by:
Hi, I am using SQL SERVER 2005 standard edition in windows xp environment. And remote system also have same SQL SERVER 2005 standard edition windows xp environment. I am using LINKED SERVER concpet to read and write the data into another database. I am able to read the data from another database. But failing to write(Insert) the data. INSERT INTO OPENQUERY(TS1,'SELECT * FROM hyi3w162.dpvsql.dbo.sampl
1
3411
by: Jimbo | last post by:
I keep getting this error on my application server...what does it mean? The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: Failed to enlist in DTC: SQL state 37000, native error 8501, error message MSDTC on server 'PROSQL' is unavailable.. ...
3
2935
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
2013
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.
5
2019
by: =?Utf-8?B?QmlsbHkgWmhhbmc=?= | last post by:
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
1
2170
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
9697
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10908
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10586
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
10648
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
9426
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
7828
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
5682
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...
1
4484
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
3134
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.