Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Error - "The valu...
Finance forum
Answered

Error - "The value's length for key 'password' exceeds it's limit"

Posted on by 20

Hello,

 I'm working in a DEV environment with Version 1611 (7.0), Platform update 9, where I'm trying to queue a build to the DevOps project after making a table extension. During the database sync step of the build, it's giving this below error in the log. 

"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'."

QueueBuildError.JPG

I have tried the solution recommended on another thread by going to the command prompt and running a decrypt on the web.config file as follows.

J:\AOSService\webroot\bin\Microsoft.Dynamics.AX.Framework.ConfigEncryptor.exe -decrypt "J\AOSService\webroot\web.config"

The database connection info in Web.config was decrypted, but I get the same error after attempting to queue the Build again. I'm wondering if the Web.Config I targeted is the correct web.config file. 

Has anyone else encountered this issue and is there another solution for this error, please?

  • Joris dG Profile Picture
    Joris dG 17,775 on at
    RE: Error - "The value's length for key 'password' exceeds it's limit"

    I think I've also seen this when certificates have expired, but then putting in the plaintext password should work I guess.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    RE: Error - "The value's length for key 'password' exceeds it's limit"

    Hi Charan,

    You can try to deploy a new DEV machine to see if that solves the issue.

  • Charan Bhamidi Profile Picture
    Charan Bhamidi 20 on at
    RE: Error - "The value's length for key 'password' exceeds it's limit"

    Unfortunately, changing the SQL Password for the user login from web.config did not resolve the error.

    "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'."

    Any other ideas, please?

  • Charan Bhamidi Profile Picture
    Charan Bhamidi 20 on at
    RE: Error - "The value's length for key 'password' exceeds it's limit"

    Hello Andre,

    Thanks for the recommendation. It is deployed on Azure, and the password for the SQL user did contain an "=" character (I confirmed in the web.config file since it's not encrypted anymore). Not sure why it would give me this error only now, since I've been using this environment for a few months. I will try to change the password, as you suggest, and see if it fixes the issue. Thanks again.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    RE: Error - "The value's length for key 'password' exceeds it's limit"

    Hi Charan,

    Is this a DEV environment deployed on Azure or a local VM? If it is a VM deployed on Azure, there can be an issue when the password contains a '=' character. This is something that is fixed in a later version. You can check if you have such password for the SQL user(s) and possibly try to change it. Or deploy a new VM, hoping for a password generation without this character.

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,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans