IBM Support

Create a datasource using Windows Authentication in Guardium

Technote (FAQ)


Question

How to create a datasource using Windows Authentication

Cause

A Datasource is needed for connectivity for Vulnerability Assessments (VA), Discovery, etc to a Windows server requiring Windows Authentication.

Answer

2 steps are required to configure an MSSQL datasource using Windows Authentication:

Step 1.) Download a JDBC driver from sourceforge.net. Note* YOU MUST GO TO THE SOURCEFORGE SITE FOR MSSQL (do not go to Microsoft or you’ll get the following error when you try to use this driver in the datasource)


Download, Extract and apply (upload to the CM) the latest jtds-xxx.jar file
e.g.
http://sourceforge.net/projects/jtds/files/jtds/1.2.5/jtds-1.2.5-dist.zip/download


Upload the JDBC driver (jar file) on the CM using the Customer Uploads function on the Administration Console:

(optional) From the CM you can then use the 'Distribute Uploaded Jar Files' to distribute the JDBC driver (jar file) to the managed units from which you need to connect using this jdbc, if any.

Step 2.) Configure datasource to use windows-authentication for MS SQL Server:

After step 1 you'll now have 2 MS SQL SERVER database types, choose the one WITHOUT "Datadirect" and configure as normal
Also add, in the connection property field domain=<your domain>



Note* The username in the datasource doesn't need to have the domain prepended.

Document information

More support for: IBM Security Guardium
Guardium Database Vulnerability Assessment

Software version: 8.2, 9.0, 9.1, 9.5, 10.0, 10.0.1, 10.1, 10.1.2

Operating system(s): Windows

Software edition: All Editions

Reference #: 1675924

Modified date: 12 February 2017


Translate this page: