All notes
SquirrelSql

Installation

Install MSSQL driver

SO: could not connect to SQL database using squirrelSQL.

  1. Go to MSDN: MSSQL JDBC driver and download. Presently JDBC only supports version 4 of the driver.
  2. Unzip the tarred JDBC driver to ~/.squirrel-sql/plugins/mssql/.
  3. Manually add the JAR path to Extra Class Path settings. Presently JDBC only supports version 4 of the driver. The newest, for example, v4.2 is OK.
  4. Add the class name: com.microsoft.sqlserver.jdbc.SQLServerDriver.