Error installing SCSP 5.2 - Unable to connect to the specified Database. Please verify the Database settings and MDAC installation. Proper installation of MDAC 2.7 SP1 or higher is required.

Products

• Critical System Protection

Issue/Introduction

During the install of the SCSP manager an error shows "Unable to connect to the specified Database. Please verify the Database settings and MDAC installation. Proper installation of MDAC 2.7 SP1 or higher is required." You've checked out the database settings and the MDAC is correct as well however the error persists.

Symptoms
A pop-up shows;

and the SISManagementInstallWrapper.log shows;

.......
Leaving CheckDBConnection()..
Unable to connect to the specified Database.
Please verify the Database settings and MDAC installation.
Proper installation of MDAC 2.7 SP1 or higher is required.
Leaving InitDBSelectDlg()..

 

Cause

1 This could be caused by the fact that the SQLbrowser service is disabled by default on the SQL server.
   The SCSP install relies on this service.

2 The customer was using the wrong database instance thus the username and password was failing during the installation.
 

Resolution

1 Enable the SQL browser service on the SQL database server.

2 Check the database instance ; using the wrong instance also produces this error message.