There are two SQL servers: FIRST - windows 2003, SQL Server 9.0.5254 and SECOND - windows 2008 R2, SQL Server 10.50.1734. SECOND runs SSIS package which select some data from FIRST. It works without any problem but every time the warning occurs on SECOND server (MSDTC encountered an error (HR=0x80000171) while attempting to establish a secure connection with system Name_of_SECONDserver). Both servers has similar MSDTC settings: Network DTC Access - ON Allow Remote Clients - ON Allow Inbound - ON Allow Outbound - ON Mutual Authentication Required - ON Enable SNA... - ON DTC Login Account - NT AUTHORITY\NetworkService Reading MSDTC log has not given any useful information. Why does it happen and how to avoid such warning?

your question is more related to sql I prefer you to post it in the sql forums http://social.technet.microsoft.com/Forums/en-US/category/sqlserver/http://www.virmansec.com/blogs/skhairuddin

I don't think so, this is not a SQL problem. There is a similar topic in this forum. However, if you are sure about it I can move it to another forum.

I don't think so, this is not a SQL problem. There is a similar topic in this forum. However, if you are sure about it you can move it to another forum.

I don't think so, this is not a SQL problem. There is a similar topic in this forum. However, if you are sure about it you can move it to another forum. I have the same problem, and my server is ONLY 2nd Domain Server and Print Server no SQL.

Hi, According to the error message, it seems sql server service was failing to communicate with clustered MSDTC since MSDTC was failing to use mutual authentication. For more information, the following blog could be helpful: Sql Server 2005 Resource Taking long time to come online on Windows Cluster with Resource Manager Creation Failed reported in Errorlog http://blogs.msdn.com/b/sqlserverfaq/archive/2009/10/14/sql-server-2005-resource-taking-long-time-to-come-online-on-windows-cluster-with-resource-manager-creation-failed-reported-in-errorlog.aspx Best Regards Dale Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Thank you Dale for you help but I did talk about clusters.