Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Certificate error afte...
Supply chain | Supply Chain Management, Commerce
Unanswered

Certificate error after database refresh during activating MPOS on VHD

(0) ShareShare
ReportReport
Posted on by Sumit Bhagat 121

Hi,

I have recently refresh my oneBox development environment database. In order to activate commerce I am following required steps after database refresh. When I am running environment re-provisioning tool, it is failing at step 3 with the error in log "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 am not able to run initialization from retail parameter it says "Encryption error".detailed error is not available. when I see in even viewer, I am getting this error "AX is shutting down due to an error. Failed to set database connection string. Exception details: Microsoft.Dynamics.AX.InvalidConnectionStringException: Failed to set database connection string. ---> System.ArgumentException: The value's length for key 'password' exceeds it's limit of '128'."

I guess, it is related to some certificate error so I tried many things, tried importing certificate from the backuped database environment, Decrypted web.config for AOS. Imported certificate from vanilla environment, change the certificate expiry date. 

I am not sure what is getting wrong here, If anybody faced same issue or knows how to resolve it. please give your inputs. Is there any table in database which stores certificate information which we can modify with thumbprint?

Thank you!

  • Abigail Profile Picture
    Abigail 550 on at
    RE: Certificate error after database refresh during activating MPOS on VHD

    This resource would help you.

    docs.microsoft.com/.../retail-modern-pos-device-activation

    Regards.

  • Sumit Bhagat Profile Picture
    Sumit Bhagat 121 on at
    RE: Certificate error after database refresh during activating MPOS on VHD

    Thank you Shaimaa. Yes, I tried this option but no luck.

  • Shaimaa Abo Gabal Profile Picture
    Shaimaa Abo Gabal on at
    RE: Certificate error after database refresh during activating MPOS on VHD

    Hi Sumit,

    For environment re-provisioning tool error "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.)" This is may be because of the DBServer Name listed in the web.config file is set to "Localhost"   however SQL is listening on the actual PC Name.

    you can try the following to Fix:

    Open Windows File Explorer  

    Right Click on This PC  > Properties

    Note the Computer Name: value

    Go to  C:\RetailServer\Webroot

    Edit the Web.config file  

    Locate the below line

    <add key="DataAccess.DbServer" value="localhost" />

    Replace "localhost" with the actual Computer Name so that is looks like

    <add key="DataAccess.DbServer" value="XXXXXX" />

    Save your change

    Run the Environment Provisioning Tool  as you normally would.  

    If you still have the issue after applying the above i would recommend you to open support incident with MS support for further investigation.

  • Sumit Bhagat Profile Picture
    Sumit Bhagat 121 on at
    Certificate error after database refresh during activating MPOS on VHD

    Hi,

    I have recently refresh my oneBox development environment database. In order to activate commerce I am following required steps after database refresh. When I am running environment re-provisioning tool, it is failing at step 3 with the error in log "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 am not able to run initialization from retail parameter it says "Encryption error".detailed error is not available. when I see in even viewer, I am getting this error "AX is shutting down due to an error. Failed to set database connection string. Exception details: Microsoft.Dynamics.AX.InvalidConnectionStringException: Failed to set database connection string. ---> System.ArgumentException: The value's length for key 'password' exceeds it's limit of '128'."

    I guess, it is related to some certificate error so I tried many things, tried importing certificate from the backuped database environment, Decrypted web.config for AOS. Imported certificate from vanilla environment, change the certificate expiry date. everything in vain.

    I am not sure what is getting wrong here, If anybody faced same issue or knows how to resolve it. please give your inputs. Is there any table in database which stores certificate information which we can modify with thumbprint?

    Thank you!

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans