An error occurs at the Configure Microsoft SQL Server MDB screen "CA IT Client Manager Setup could not validate the given settings Database provider from type 'MsSQL' was installed on server %SERVERNAME% with an incorrect authentication mode."

Document ID : KB000029093
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

This article describes how to configure SQL Server authentication to resolve the installation error. 

 

Cause of issue:

The SQL server was installed or configured with Windows authentication only.

 

Solution:

Change the SQL security mode to SQL Server and Windows Authentication mode following the following steps

Screenshot of install error:

SS1.png 

1) Cancel out of the installation

2) Open SQL Management Studio and browse to the Server and select properties

ss2.png 

 

3) In the Server properties screen click Security  

ss3.png

4) Under SQL Authenticate select the option SQL Server and Windows Authentication mode

 

ss4.png

5) Click OK

 

6) Click OK

ss5.png

7) Right click on the server name and select restart and confirm its OK to restart

 

ss6.png

 

8) Rerun setup of CA Client Automation and the error should not occur.