Data Loss Prevention

i am testing DAR scanning for SQL2008 R2 server in our environment and keep getting the following:

"Unable to create a database connection: Unable to load driver for sqlserver."

I am utilizing the string below: 

 following what I found in the documentation: 

the account I have configured within this scan currently has db_reader rights to the database - is there anything else needed? 

Thanks in advance - 

JN

what is teh DLP version? did you check if it works?

sqlserver://sqlserver.company.com:1433/mydatabase;instance=myinstance

11.6.1000.20056 is the version - and to this point, I have not specified an instance.  Is that required? 

im not sure if the sql 2008 target is supported. can you check with support?

i will go that route - thanks.  

JN

It seems that DLP isn't able to load the jdbc driver, please check both jdbc driver and sqldatabasecrawler.properties on DLP Network Discover.

I used jtds-1.2.2.jar without problems.

Giovanni

Thanks Giovanni - I got it working by utilizing the following syntax:

sqlserver://<servername>:port/db_name

our SQL admin also created a SQL account to use for these scans, and after testing these out - I was able to scan databases with success.  

DBO (Database Object Owner) is the account required to scan the SQL Database.

The credentials you provide must have both Read permission and Write Attributes permission on the scan target. Write Attributes permission is required in order to update the "last accessed" date.