Solved

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

Posted on 2016-09-20
4
1,530 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
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…

626 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