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."
search cancel

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."

book

Article ID: 29093

calendar_today

Updated On:

Products

CA Client Automation - IT Client Manager CA Client Automation

Issue/Introduction

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

 

Environment

Client Automation - All versions

Cause

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

Resolution

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

Screenshot of install error:


1) Cancel out of the installation

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

3) In the Server properties screen click Security  


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

 

5) Click OK

 

6) Click OK

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

 

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

Powered by Wolken Software