Link to home
Create AccountLog in
Windows Server 2008

Windows Server 2008

--

Questions

--

Followers

Top Experts

Avatar of Ladapa Charnyingyong
Ladapa Charnyingyong🇺🇸

what can possibly cause MSDTC malfunction?
Our application, coded based on .NET 2005 Framework 3.5 SP1, stops working when we move from Windows 2003 to Windows 2008 server 64-bit.  Our application is still running on 32-bit though but that should not be an issue.

The following error occurs:
(from Windows Event Viewer -Window event error ids are 4212 and 4217)
"The transaction has aborted. MSDTC was unable to read its configuration information. (Exception from HRESULT: 0x8004D027)"

To fix this error, we had to uninstall and reisntall MSDTC service by issuing mstdc –uninstall/install command then restart MSDTC service.

We are doubt whether the MSDTC on our Windows 2008 server was originally installed properly?  There is no error, no log or no sign that we can verify.  This happens on every server because we are using the same image to create the Windows.

Is there a utility or some method to verify MSDTC whether it is installed properly?  We thought of using DTCPING utility however it DOES NOT work on Windows 2008.

We suspect that some patches may cause MSDTC malfunction, have anyone had similar issue?

All comments/advice are VERY welcome.

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Avatar of Jim P.Jim P.🇺🇸

DTC was replaced with SQL Server Integration Services (SSIS) in 2005. It is probably been completely deprecated in 2008. My guess is you are going to have to rebuild it with SSIS.

http://msdn.microsoft.com/en-us/library/ms141026.aspx
Avatar of seg42canseg42can

There are both 32 and 64 bit exes and you have to tell it which one to run by specifying the complete path name you will be sure to be running the correct one--
Avatar of seg42canseg42can

misread problem-- so answer above is not correct regarding 32 and 64  bit exe
Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Avatar of Ladapa CharnyingyongLadapa Charnyingyong🇺🇸

ASKER

Our machine does not install SQL Server.  So, DTC should not be replaced by SSIS, right? BTW, please advice me if I misunderstood.

Thank you very much for both of you.


Avatar of Jim P.Jim P.🇺🇸

How does the MSDTC connect to the SQL Server -- OledDB or ODBC?

If it is ODBC -- then you need to create an ODBC call via the SySwow directory.


You have to fire it from the Start --> Run --> C:\Windows\sysWOW\odbcad32.exe Then it should work. Delete the other ones first though so there isn't confusion.
ASKER CERTIFIED SOLUTION
Avatar of Ladapa CharnyingyongLadapa Charnyingyong🇺🇸

ASKER

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of Ladapa CharnyingyongLadapa Charnyingyong🇺🇸

ASKER

Problem is resolved.
Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Windows Server 2008

Windows Server 2008

--

Questions

--

Followers

Top Experts

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.