"Unable to connect to the Database" error while upgrading SCSP Server from 5.2.8 to 5.2.9

book

Article ID: 157076

calendar_today

Updated On:

Products

Critical System Protection

Issue/Introduction

You have downloaded SCSP 5.2.9 source, and you ran server.exe file on your SCSP Server in order to upgrade it, but upgrade fails at database credentials stage. You confirmed credentials are correct by using osql command and connecting to SCSP database via SQL Server Management Studio.

SQL Server error log do not show login failure event. SQL Browser service is started on database server. If you cancel upgrade wizard, you can log in to 5.2.8 console and manage your agents without any issue.

 

"Unable to connect to the Database with the specified username and password. Please verify the Database settings"

 

 

Cause

SCSP upgrade wizard is unable to reach database server.

 

Resolution

1. Open SQL Server Configuration Manager on SCSP Server side.

 

2. Go to Aliases

 

3. Configure an alias as follow:

     - Alias name: [SQLSERVERNAME]\MSSQLSERVER

     - Server: [SQLSERVERNAME]

     - Protocol: TCP

     - Parameters: custom SQL Server port

 

 4. Run the upgrade

 


Applies To

SCSP 5.2.8 with remote SQL Server database, using a custom port.
Default SQL Server instance is used (MSSQLSERVER).

 

Attachments