Changing SQL Server Password

Product: Everest Advanced Edition

Version: 4.0 and above

QUESTION

We have changed the System Admin (SA) password on the SQL server. The online shop files are located on a separate web server. How do I communicate the new SA password to the webserver without running the setup again?

ANSWER

If you change the SA password of the SQL server, then the client will neither be able to log into Everest database nor the webserver. The SA password is a must for Everest as it is used to log in and connect to the database. You cannot have any other user, even if the user belongs to the same SA group. If you change the SA password for the SQL server, it is mandatory that you update the same in Everest.

To communicate the new password:

1 Go to C:\Program Files\Icode\Everest\Client\Utilities (assuming that you installed Everest in the default installation path) and click ChangeLoginPassword.exe.

2 Specify the SQL Server Name.

3 In the Options section, select Change SQL Server User name/Password.

4 Change the Old User Name to "SA". (it should in fact be showing an encrypted user name as a default)

5 You will be prompted to enter the old password. 

6 Change the New User Name to "SA". (it should in fact be showing an encrypted user name as a default)

7 Enter the new password for SA and confirm by retyping the password.

This should allow the Everest client to login with the new SA password.

Everest is a registered trademark of Everest Software, Inc. All other product names and services referenced herein are trademarks of their respective companies.

Disclaimer:

The third-party product that this document confers is created by companies that are independent of Everest software. Everest Software makes no warranty, implied or otherwise, regarding the performance or consistency of this product.