Overview

While performing a version upgrade, the installer may fail to connect to the ListManager's MS SQL database when the integrated authentication is defined.

The installer presents the message "The parameters to connect to the Database are wrong or invalid. Please check!":

Error message for database connection.

Additionally, in the log file there's the message: Unable to connect to SQL database with settings provided in configuration file.

When using integrated authentication with the Lyris LM's database, the lmcfg.txt configuration file will have the credentials set to empty:

$sql_user="";
$sql_password="";

It means that the currently logged-in user will be used to connect to the database.

Solution

This situation can occur when the LM services are running under a different account than the one used for the upgrade process.

The account for the services has the proper access to the database, therefore the system runs without any issues, whereas the logged-in user does not.

To solve the issue, the currently logged-in user, which is running the installer, must also have at least the same access to the database so all the required updates are performed.