search cancel

Scanning SQL with Windows Authentication(NTLM).

book

Article ID: 162025

calendar_today

Updated On:

Products

Data Loss Prevention Network Discover

Issue/Introduction

When scanning SQL databases such as MSSQL.  Is it possible for the scan user to authenticate through windows instead of directly through a database user?
 

Resolution

You can accomplish this by adding domain=<name of domain> into the connection string (separated from the rest of the connection string by a semicolon, see attached screenshot) and not including it in the username field.
This should pass the credentials along in a way that NTLM understands and will allow NTLM to authenticate and grant access to the database with your scan user that is an AD user.