CIS-CAT Pro Assessor GUI v4.2.0 SQL 2019 connection problems
Product Name
CIS-CAT Pro Assessor v4
Product Version
v4.2
Date
Feb 2, 2021
Problem
I have not been able to get the JDBC connection string to work to assess Server 2019 SQL 2019.
When I try the default string jdbc:jtds:sqlserver:localhost:1433;IntegratedSecurity=true I get an error when I hit Test Connection "Connection Failed. Either no connection string was entered or it is invalid"
I am running Assessor locally on the SQL server.
Solution
Log into MSSQLSMS with your credentials and check you can access and read the DB on the system you are assessing.
Using that credential information to construct the jdbc string. Use this section from the Documentation for specific examples and information. For this scenario the local MSSQL 2019 Assessment JDBC string will be
jdbc:jtds:sqlserver://localhost:1433;DatabaseName=ccpd;user=sa;password=secretpasswdStart CIS-CAT Pro GUI, select "Basic Scan this system only" and select the SQL Server 2019 Benchmark and Profile and select “Add”. There is a popup to test the DB connection, replace the default information with your constructed jdbc string from step 2.
Select the “Test Connection” button.
If the information you entered is correct you will get a message of "Database Connection Test Successful" and you can then proceed with the assessment
If you get an error on the Test Connection please review the information in the CIS-CAT Documentation and if needed reach out to your DBA for assistance.
Keywords jdbc MSSQL