Solved

MSDTC encountered an error (HR=0x80000171) while attempting to establish a secure connection with system

Posted on 2016-09-20
4
701 Views
Last Modified: 2016-11-05
Windows 2012 R2 standard
SQL 2014 Standard

when attempting to setup the DTC security settings in the Component Services console, i get this error:
"An error occurred attempting to recover from a previous error. DTC may not work correctly."

Also, the event viewer logs this:
"MSDTC encountered an error (HR=0x80000171) while attempting to establish a secure connection with system"

It is using the network service as the DTC logon account. I have tried the local service, local admin, domain admin; same issue.
I have given the network service full permissions to the msdtc log file.

any ideas?
0
Comment
Question by:davidg004
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 27

Expert Comment

by:Dan McFadden
ID: 41808625
You need to enable network access by configuring the dtc service.

Link:  https://technet.microsoft.com/en-us/library/cc753620%28WS.10%29.aspx?f=255&MSPPError=-2147217396

Dan
0
 
LVL 27

Expert Comment

by:Dan McFadden
ID: 41829897
Did the above info help resolve the issue?

Dan
0
 

Accepted Solution

by:
davidg004 earned 0 total points
ID: 41834016
no, i had to reinstall the dtc role/feature
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question