DTC cannot establish secure connection
Question
Tuesday, January 26, 2010 7:57 PM
I have Vista Ultimate 64 and have recently installed SQL Server 2005 to run as "local system" as I don't have a server. I am an absolute beginner with SQL Server and am wanting it for learning and development, my background is as a database/ software developer with MS Access.
Each day on starting the computer I get the following in the event log:
Log Name: Application
Source: Microsoft-Windows-MSDTC Client 2
Date: 26/01/2010 09:12:06
Event ID: 4879
Task Category: CM
Level: Warning
Keywords: Classic
User: N/A
Computer: <computer name>
Description:
MSDTC encountered an error (HR=0x80000171) while attempting to establish a secure connection with system <computer name>.
I have found a document for enabling network access security for MS DTC on http://technet.microsoft.com/en-us/library/cc753620(WS.10).aspx
My question is this necessary when I do not need to comunicate with another machine? is it going to cause problems?
Dani.
All replies (2)
Tuesday, January 26, 2010 9:25 PM âś…Answered
MSDTC service is required only if you are calling remote stored procs or connecting to other SQL server instances in network through linked servers and other oledb data sources.
If you are not doing those, then you can ignore these warning messages.
An architectural explanation of MSDTC for SQL server is explained here http://msdn.microsoft.com/en-us/library/aa174499(SQL.80).aspx
And if you are keen on solving the error then have a look at http://social.technet.microsoft.com/Forums/en/winservergen/thread/eb8835d9-5f5b-4df2-8c68-4a61d5e44d6b and
Thanks, Leks
Wednesday, January 27, 2010 8:19 AM
Thanks so much Leks for your excellent answer. I will look at the links but I need not worry about it.
Dani