Windows Authentication for Microsoft SQL Server Network Discover scans

Products

• Data Loss Prevention Network Discover

Issue/Introduction

Attempting to create scans to a Microsoft SQL Server target, but you are receiving authentication errors.

Unable to create a database connection: Unable to create a connection: jdbc:jtds:sqlserver://<server_address>:<port>;, Reason: Login failed for user '<username>'

Environment

Data Loss Prevention 15.1, 15.8
Network Discover

Cause

Active Directory authentication uses Kerberos, which is not supported for this connection. NTLM authentication will need to be used.

Resolution

Change your connection string to something similar to the following:

sqlserver:/<server_address>:<port>/<DB_instance>;useNTLMv2=true;domain=<domain.com>

Once that string has been changed, test another scan.