Restriction of characters in CRM passwords

By | November 30, 2016

In Sage CRM, user’s password is encrypted both within the system and in the database for maximum security. The System Administrator can change, but not view, a user’s existing password.
There are four restricted characters in Sage CRM, you cannot use these characters in the beginning of the users password. These characters are “#“, “^“, “$” and “&“.
New Stuff: Creating SSA field dynamically using Sage CRM .NET API
If any one of these characters is used in the beginning it may lead to issue decrypting a user password and hence result user will not able to access the CRM system. These may affect either eWare DLL or the CRM Tomcat webapps.
Generally, in this scenario User will face below issues while login to the Sage CRM.
1) You may need to recreate views manually
2) Could not open connection” / “Error creating bean
The following characters are restricted for use as the first character of a password.

Character Usage
$ Encrypted string (deprecated)
# Encrypted string (deprecated)
^ One-way hash. Used for user passwords.
& Encrypted string. Used for database connection passwords, and other content that needs to be decrypted.

We can use these characters elsewhere in the password without any issue. Data stored in other fields can begin with these characters. Hence Passwords used with CRM, in particular database passwords, should not start with these four characters.
This is by design, as some method needs to be used to indicate whether a string is encrypted, and what encryption method is being used.
About Us
Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.
Greytrix has some unique integration solutions for Sage CRM with Sage ERP’s (Sage X3Sage 100Sage 500 and Sage 300). It also offers best-in-class Sage ERP customization and development services to Business Partners, End Users and Sage PSG worldwide. Greytrix helps in migrating to Sage CRM from ACTGoldmine and other CRM’s.
For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.
Also Read:
1) Implementing Password Policies in SageCRM
2) Set field text type to Password on CRM screen at run time
3) Password Security for Sage CRM Self Service Portal
4) Password Checker in CRM while creating users.
5) Want to increase Self-Service Password field size?