Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / SSL Provider, error: 0...
Finance forum
Answered

SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.

Posted on by 445

I am doing a certificate rotation process for D365FO(on-premise). I just completed generating the SQL Server certificate. Now the problem comes when deploying. The AXSFType is displaying this error: 

'System.RA' reported Warning for property 'ReplicaOpenStatus'.
Replica had multiple failures during open on AOS-02. API call: IStatelessServiceInstance.Open(); Error = Microsoft.Dynamics.AXService.Database.DBSyncInvokeException (-2146233088)
DBSync failed. Please check the logs.
at Microsoft.Dynamics.AXService.Database.States.DBSyncFailedState.ApplyThenTransition()
at Microsoft.Dynamics.AXService.AXService.Synchronize(String codePackageVersion, ILogger logger)
at Microsoft.Dynamics.AXService.AXService.<>c__DisplayClass9_0.<.ctor>b__0()

The AOS event logs are showing the below events

02/03/2021 16:34:38: Caught unexpected exception: System.AggregateException: Unable to connect to SQL server. ---> System.Data.SqlClient.SqlException: 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.) ---> System.ComponentModel.Win32Exception: The certificate chain was issued by an authority that is not trusted --- End of inner exception stack trace --- at System.Data.SqlClient.SqlInternalConnectionTds..ctor(...)

Anyone with the idea how to solve the "SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted."?

  • Verified answer
    Huggins Mafigu Profile Picture
    Huggins Mafigu 445 on at
    RE: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.

    Hie guys,

    "Adding the public key SQL Server certificate to all the Service Fabric nodes"  only did not solve my problem. I added the .cert to the Trusted Root Certification Authorities of all the nodes i.e. AOS nodes, OR nodes, MR and SSRS nodes. And the error cleared away.

  • WillWU Profile Picture
    WillWU 22,344 on at
    RE: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.

    Hi Huggins Mafigu,

    Please read this document ,"gateway fails to deploy". Your error message is documented under this topic.

    Reason: The pointers to the performance counter that the gateway needs may be corrupt.

    Resolution: Run lodctr /R in a Command Prompt window that you open as administrator in all AOS nodes where the gateway is unhealthy. If you receive an error message that states that the performance counters can't be rebuilt, try to run the command again.

    Refer to:docs.microsoft.com/.../troubleshoot-on-prem

  • Suggested answer
    ergun sahin Profile Picture
    ergun sahin 8,812 Super User on at
    RE: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.

    "To resolve this error, add the public key SQL Server certificate to all the Service Fabric nodes."

    docs.microsoft.com/.../troubleshoot-on-prem

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,914 Super User on at
    RE: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.

    Hi Huggins,

    Have you performed all steps like outlined in the documentation?  Certificate rotation - Finance & Operations | Dynamics 365 | Microsoft Docs

    Also ensure you are not using a self-signed certificate on a production environment.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans