search cancel

Windows Authentication for Microsoft SQL Server Network Discover scans

book

Article ID: 173793

calendar_today

Updated On:

Products

Data Loss Prevention Network Discover

Issue/Introduction

Attempting to create scans to a Microsoft SQL Server target, but getting 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>'

Cause

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

Environment

Data Loss Prevention 15.1
Network Discover

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.