web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Unanswered

Certificate error after database refresh during activating MPOS on VHD

(0) ShareShare
ReportReport
Posted on by 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!

I have the same question (0)
  • Sumit Bhagat Profile Picture
    121 on at

    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!

  • Shaimaa Abo Gabal Profile Picture
    on at

    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
    121 on at

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

  • Abigail Profile Picture
    552 on at

    This resource would help you.

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

    Regards.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 298 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 183 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 118 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans