Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2016-09-20
4
Medium Priority
?
2,162 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 28

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 28

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

721 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