You are unable to connect to database

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.

Update

This method of holding the database connection credentials was changed in 2018, Job versions 9.02.405/9.03.205.
The Eralis_Setpassword.exe utility is no longer used.  The database connection is set via the UI and details are held in the @ENP_SETTINGS table.

To update the dbase connection password, first remove the existing connection information:

     DELETE FROM "@ENP_SETTINGS" WHERE U_SECTION = "DB_CONNECTION"

Then start the Job add-on which will prompt for new connection information.  Note that when you open SAPB1 you should do this 'As Administrator', and the login user should be a superuser (such as manager).