Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

CRM 2013 IFD install requires encrypted connection to SQL server using tls1.2

Posted on by Microsoft Employee

Hi,

we have a working install of Dynamics 2013, IFD, local AD, CRM and SQL servers.

As part of PCI compliance we had already configured SQL server to require encrypted connection and everything works fine.

Now we've disabled SSL and TLS1.0 and CRM can no longer connect to SQL Server.

The Application log on CRM server now reports either;

Exception: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

or

The instance of SQL Server you attempted to connect to requires encryption but this machine does not support it.

I can create and test an ODBC SQL Native Client connection from the CRM server to SQL server with encryption etc... and it connects successfully.

When I include the same parameters into the configDB registry setting to specify the encryption and to trust the server certificate, it seems they get ignored? as the error message remain the same.

Does CRM 2013 support a TLS1.1 or TLS 1.2 encrypted connection to SQL server?

Thanks

Lucas

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM 2013 IFD install requires encrypted connection to SQL server using tls1.2

    Lucas, did you ever find an answer to this. We seem to be dealing with the exact same problem, where CRM 2013 will not connect to a database that requires encryption and has TLS 1.0 disabled.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans