Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Two tier. Service and ...
Microsoft Dynamics NAV (Archived)

Two tier. Service and SQL Tier encrypted communications problem.

(0) ShareShare
ReportReport
Posted on by Graziano Tartari 220

I follow some "how to" to configure encryption between a NAV server tier and a SQL server tier.
I created a key and I import it. The key is succesfully created. I set up the NAV service with database credentials.
I cannot connect to DB with the error:

"Message: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)"

I cannot find any guide to configure certificate. Dynamics Nav guide does not mention certificates. 

 

Graziano.

 

*This post is locked for comments

  • Graziano Tartari Profile Picture
    Graziano Tartari 220 on at
    RE: Two tier. Service and SQL Tier encrypted communications problem.

    SQL Server 2014.

    Both on "No" either 32 and 64 bit. Turn yes the result does not change.

    But I think the problem is on NAV side...

    Regards,
    Graziano.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Two tier. Service and SQL Tier encrypted communications problem.

    What SQL version are you using? What value do you have in ForceEncryption property of SQL server? What value do you have in "Enable trust of SQL server certificate" property of NAV server setup (better, provide your screenshot here).

  • Graziano Tartari Profile Picture
    Graziano Tartari 220 on at
    RE: Two tier. Service and SQL Tier encrypted communications problem.

    Alexander,
    you have suggested a guide regarding another question: the client encryption.

    My question is: is the certificate used in client encryption the same used in DB encryption?

    Now, in my problem envinroment, where is the certificate causes the issue?? I did not installed anything...

    I installed a fresh NAV server, a fresh SQL server, followed a guide like this 

    https://msdynamicsnavashwinitripathi.wordpress.com/2015/10/30/configuring-sql-server-authentication-in-microsoft-dynamics-nav-2016-part-1/

    and finally got the error.

    The question could be: does the thumbprint of a valid certificate in the NAV service help both client encryption and especially DB encryption?
    If the answer was yes the guide might be specify to set up the thumbprint of a valid certificates before implement DB encryption...

    Regards,
    Graziano.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Two tier. Service and SQL Tier encrypted communications problem.

    This might be an issue, related to SQL connectivity. You need to try to either obtain a trust certificate from trusted authority, or make setting that SQL will use self-signed certificates.

    msdn.microsoft.com/.../gg502467(v=nav.90).aspx

    help.lsnav80.lsretail.com/.../tskImplementSecurityCertificatesInProductionEnvironment.htm

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans