Data Loss Prevention

 View Only
  • 1.  Symantec DLP 11.5 SQL Scanning - MS SQL Server Configuration

    Posted Aug 29, 2012 02:11 PM

    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.



  • 2.  RE: Symantec DLP 11.5 SQL Scanning - MS SQL Server Configuration

    Broadcom Employee
    Posted Aug 29, 2012 02:19 PM

    is the browser services of sql running?

     



  • 3.  RE: Symantec DLP 11.5 SQL Scanning - MS SQL Server Configuration

    Broadcom Employee
    Posted Aug 29, 2012 10:42 PM

    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



  • 4.  RE: Symantec DLP 11.5 SQL Scanning - MS SQL Server Configuration

    Posted Aug 30, 2012 08:47 AM

    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.