/
SQL Server Authentication issues in CIS-CAT Pro Assessor

SQL Server Authentication issues in CIS-CAT Pro Assessor


Product Name

CIS-CAT Pro Assessor

Product Version

All

Date

Jun 14, 2021



 

Problem

Connection using JDBC string fails using Domain Accounts

 

Solution

Please try one of the following modifications to the JDBC string:

  1. add authenticationScheme=NTLM to JDBC connection string

  2. If the database accepts Windows authentication for your domain user, use just integratedSecurity=true instead of domain, user, and password. This will use the domain, user, and credentials of the user logged onto the machine on which CIS-CAT is being run.

Keywords;

Content by Label


Copyright © 2020

Center for Internet Security®


 

Related content

CIS-CAT Pro Assessor GUI v4.2.0 SQL 2019 connection problems
CIS-CAT Pro Assessor GUI v4.2.0 SQL 2019 connection problems
More like this
Quick Start Guide: Non-Domain Joined MS SQL Database Scanning (GUI)
Quick Start Guide: Non-Domain Joined MS SQL Database Scanning (GUI)
More like this
Quick Start Guide: MSSQL Database Scanning w/ Integrated Security (GUI)
Quick Start Guide: MSSQL Database Scanning w/ Integrated Security (GUI)
More like this
Quick Start Guide: CSAT Pro Installation
Quick Start Guide: CSAT Pro Installation
Read with this
CIS-CAT Pro Assessor Command line usage -D
CIS-CAT Pro Assessor Command line usage -D
More like this
Enabling RDP when applying a CIS Windows Build Kit
Enabling RDP when applying a CIS Windows Build Kit
Read with this