Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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.