Invalid SQL Server parameters [Kaspersky Security for Microsoft Exchange Server]

[Antipova Anna]

Advice and Solutions (Forum Knowledgebase) Disclaimer. Read before using materials.

Version: KSE for Microsoft Exchange Server versions 9.5.10000.64, 9.6.96.

Scenario: We have established a workaround to a problem with invalid SQL server parameters during its installation.

An error about invalid SQL server parameters occurred during the installation: "The server was not found or was not accessible. Verify that the instance name is correct, and that SQL Server is configured to allow remote connections. Error 26 - Error Locating Server/Instance Specified".

We have found the following information from installation log:

Installation log showed the SQL server "CRATER\SQLEXPRESS" was used for the installation:

We found that the configuration file "BackendDatabaseConfiguration*.config" which was used for configuring the SQL server was using the server name "CRATER".

Solution:

If you're sure that "CRATER\SQLEXPRESS" is the real name of the SQL server,  replace "CRATER" in the SQL server name by "CRATER\SQLEXPRESS" in the following objects:

1. "X:\%KSE_Folder%\Configuration\BackendDatabaseConfiguration*.config" file.

If there are several such files in this folder, do it for all of them.

2. In the system registry "HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Kaspersky Lab\Kaspersky Security for Microsoft Exchange Server".

Parameter is BackendSqlServerName.

Start the upgrade again.