When starting up one of the Eralis add-on products, the system may pop up the following message box:
You are unable to connect to database <<database name>> on server <<SQL server Name>>
Eralis <<product name>> will now terminate
Error: Login failed for user <<sql user>> (normally sa)
Essentially the add-on is having a problem connecting to the SQL database.
The most common reason for this is incorrect SQL credentials, or SQL credentials that have changed.
To resolve this you will need to run the Eralis_Setpassword.exe utility.
This utility will reset the SQL credentials that the system uses.
The utility can be found in the add-on folder, which is generally found in the following path:
C:\Program Files (x86)\SAP\SAP Business One\AddOns\Eralis Solutions\<<Eralis Product Name>>
Please note however, if you are running a Windows 7 / Windows 2008 or generally any environment where you do not have administrator privileges, the utility will not work.
You need to have administrative privileges to the environment. Choose the right click option to Run as Administrator when you launch the Eralis_Setpassword.exe utility.
The utility will prompt for:
- The SQL user account to connect with (sa is the system administrator).
- The SQL user account password.
- A verification of the SQL user account password.