Adding a password to the SQL sa user account

This is another that came as a result of a support request. If you change the SQL password of the login used by CRM, CRM will stop functioning correctly. So, if you DO have to change this password, follow this procedure to ensure everything happens smoothly

1. First, change the password in CRM by going to Administration, System and then database. Update the "Database Password" field on this screen
2. Now log everyone out of CRM and change the password in SQL to match the password in step1
3. finally restart IIS and try logging in

If for any reason you cannot login, you will have to blank out the password in SQL so that you can get back into the system to try again, as CRM encrypts the password in the registry so that you cannot enter it manually. To do this, ensure that you set the password in SQL to be blank, and then blank out the following registry key

HKET_LocalMachine\Software\eWare\Configuration\Databasepassword

Both CRM and SQL will now have a blank password, and you should be able to get back into the system.



Visit Centurion for more expert advice