Data Loss Prevention

Running DLP v.11.1.0.07015

I got Endpoint, Exchange, File System discovery scans to work, but having trouble with the SQL scan.

SQL Scan fails with the error:  "The crawler threw an exception. Check the logs for more details "

I've exported the system logs Network Discover Server, looked at the logs, but uncertain what information to look for. 

The Discover Trace log shows:

13/Oct/11:11:35:49:531-1000 [INFO] (DISCOVER_TRACE.500) Received start command for Discover Manager: DiscoverControlManager_1 for Walk ID: 149
13/Oct/11:11:35:49:531-1000 [INFO] (DISCOVER_TRACE.503) Transitioning to state LOADING_WALK
13/Oct/11:11:35:49:531-1000 [INFO] (DISCOVER_TRACE.503) Transitioning to state CRAWLING_AND_DETECTING
13/Oct/11:11:35:49:531-1000 [INFO] (DISCOVER_TRACE.503) Transitioning to state COMPLETING_CRAWL
13/Oct/11:11:35:49:547-1000 [INFO] (DISCOVER_TRACE.503) Transitioning to state IDLE 

Scan Detail log shows:

"Oct 13, 2011 11:35:49 AM","INFO","Databasename 10/13/11 - 11:35 AM","STARTED_SEGMENT","instance=sqlinstancename","0","","","",""
"Oct 13, 2011 11:35:49 AM","WARNING","","FAILED_SCAN","","0","The crawler threw an exception. Check the logs for more details","","",""
 

What version is your SQL Server and JTDS driver?

JTDS 1.2.5. ; SQL 2000

Placed the entire contents of the JTDS download in \vontu\protect\lib\jtds.  Edited connection.properties.tmpl file in \jtds\conf folder to reflect SQl server name and database.  Still receive the same error message. 

#
# The URL of the server to which you want to connect
#
# Replace SERVER-NAME with the name of your server (also in the SERVERNAME
# property)
#
# Replace DB-NAME with the name of the database to use (also in the
# DATABASENAME property)
#
driver=net.sourceforge.jtds.jdbc.Driver
url=jdbc:jtds:sqlserver://SERVER-NAME/DB-NAME
USER=sa
PASSWORD=
SERVERNAME=SERVER-NAME
PORTNUMBER=1433
DATABASENAME=DB-NAME
SERVERTYPE=1
XAEMULATION=true 

You are not properly registering the driver for Vontu to use.

Copy the following files from the JTDS 1.2.5 driver:

jtds-1.2.5.jar > Protect\lib\jdbc

You need nothing else..

Edit the sqldatabasecrawler.properties file in the \vontu\protect\config directory. You will need to update the version number of the JTDS driver in the file for Microsoft and the Sybase sections.

driver_jar.sqlserver = jtds-1.2.5.jar

driver_jar.sybase = jtds-1.2.5.jar

Then when creating the DB target in the UI you will need to specificy the target using the verbiage stated in the help screens.

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

The help screen also tells you how to register a JDBC driver.

It worked.  Thank you.

Im running into a similar issue:

you need to make sure the line is correct..

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