JTDS driver connection string info for SQL Server Discover scanning.

Products

• Data Loss Prevention Network Discover

Issue/Introduction

While attempting Discover scans using the JTDS driver, typical connection strings syntax involving domain information results in failure to connect errors.

Environment

15.X, 16.X

Resolution

If you are using a domain account for scanning SQL Server databases, the syntax of “<domain>\<username>” in the credentials field of the scan will not work.  This syntax will cause a login error on the scan. 

 

In order to specify the domain, it must be included in the database connection string using the following syntax:

 

SQLSERVER://<server>:<port>/<database>;domain=<domain>

 In the scan credentials field, you then must specify the domain user name without the domain qualification.