- Install Squirrel SQL.
- Download Microsoft JDBC Driver for SQL Server.
- Unpack JDBC Driver to a known location.
- Open Squirrel SQL
- From the menu bar, select Drivers > New Driver
# For the purpose of this example, [...] indicates a button.
Name: MSSQL
Example URL: jdbc:sqlserver://<url>:<port>;databaseName=<db name>;
Website URL: http://msdn.microsoft.com/en-us/library/ms378428(SQL.90).aspx
# Add the JDBC driver
[Extra Class Path] > [Add]
<JDBC Driver Location>/enu/sqljdbc4.jar
[Choose]
Class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver
[OK]
Thank you very much for this! Was really handy today.