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.