Video Screencast Help

Symantec DLP 11.5 SQL Scanning - MS SQL Server Configuration

Created: 29 Aug 2012 • Updated: 11 Sep 2012 | 3 comments

When attempting to scan a Microsoft SQL 2008 database using Symantec DLP Discover 11.5, you receive the following error in the Discover task:

Unable to create a database connection: Unable to create connection: jdbc:jtds:sqlserver://server.name.com:1433/dbname;instance=mssqlserver, Reason: Unable to get information from SQL Server: server.name.com.

The FileReader log has the following entry:

Aug 29, 2012 10:10:05 AM com.vontu.discover.target.sqldatabase.SQLDatabaseCrawler sendFailureCheckpoint
SEVERE: Unable to create a database connection: Unable to create connection: jdbc:jtds:sqlserver://server.name.com:1433/dbname;instance=mssqlserver, Reason: Unable to get information from SQL Server: server.name.com.
java.lang.Exception: Unable to create connection: jdbc:jtds:sqlserver://server.name.com:1433/dbname;instance=mssqlserver, Reason: Unable to get information from SQL Server: server.name.com.

You have the JDBC driver installed in the [%VONTU ROOT%]\Protect\Lib\jdbc folder and the sqldatabasecrawler.properties file is pointed to the correct driver.

MS SQL is listening on port 1433 and the database is running

SOLUTION: Ensure that the SQL Server Browser Service is running.  By default, this service is disabled.  Change the startup to Automatic and start the service.

Comments 3 CommentsJump to latest comment

yang_zhang's picture

I think your connection string is wrong:

jdbc:jtds:sqlserver://server.name.com:1433/dbname;instance=mssqlserver

the right one should be:

sqlserver://server.name.com:1433/dbname;instance=mssqlserver

If a forum post solves your problem, please flag it as a solution. If you like an article, blog post or download vote it up.
Rincewind's picture

Thank you for adding comments, Pete and Yang.

The SQL Server Browser service is running and I wanted to post some information about the SQL browser service because the forum did not retrieve any results for the "Unable to create connection error" that recommended a check of the SQL Server Browser service.  I found a reference to a browser service check at http://stackoverflow.com/questions/5530816/java-problem-connecting-to-sql-server

As Yang noted, the connection string entry in the DLP console needs to be

sqlserver://server.name.com:1433/dbname;instance=mssqlserver

The error is reported as the full JDBC connection string, which includes the jdbc:jtds: driver call.