November 2, 2008 at 4:41 am
Hi
I'm getting the following error in SQLSERVER 2000
"1 Commit of internal MSDTC transaction failed: Result Code = 0x8004d019."
How can i solve this??
November 2, 2008 at 5:01 am
Hi,
When do you get this error and what version of the OS are you running?
Depending on what Windows version you are on; check
http://support.microsoft.com/kb/817064 "How to enable network DTC access in Windows Server 2003"
http://technet.microsoft.com/en-us/library/cc753510.aspx "Enable DTC Access" (Windows Vista and Win 2K8).
If this is not the issue, use the DTCPing tool to test the connectivity between the servers:
http://www.microsoft.com/downloads/details.aspx?FamilyID=5e325025-4dcd-4658-a549-1d549ac17644&DisplayLang=en (instructions are in the Readme.txt file).
HTH!
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply