Configuring SquirrelSQL and MSSQL

sqlserver_setup.rst

Configuring SquirrelSQL and MS SQL

1. Install Squirrel SQL.
2. Download Microsoft JDBC Driver for SQL Server.
3. Unpack JDBC Driver to a known location.
4. Open Squirrel SQL
5. 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]

Helped. Thank you.

Happy Coding.

Great!

1. * Download driver (*.jar file) from Maven Central (https://search.maven.org/#search%7Cgav%7C1%7Cg%3A%22com.microsoft.sqlserver%22%20AND%20a%3A%22mssql-jdbc%22)

2. * Move jar file to Lib folder (In MAC: /Applications/SQuirreLSQL.app/Contents/Resources/Java/lib/)

3. * Open Squirrel SQL

4. * Check that you see "Microsoft MSSQL Server JDBC Driver" in the drivers list

You can also use ' jTDS Microsoft SQL' (http://jtds.sourceforge.net/) as above

If you using Linux SO, so find locate your setup the squirrelSQL, and mode jar file in Lib Folder