Skip to content

Instantly share code, notes, and snippets.

@willist
Created May 23, 2012 14:14
Show Gist options
  • Save willist/2775454 to your computer and use it in GitHub Desktop.
Save willist/2775454 to your computer and use it in GitHub Desktop.
Configuring SquirrelSQL and MSSQL

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]
@carestra
Copy link

carestra commented Jul 9, 2018

    • Move jar file to Lib folder (In MAC: /Applications/SQuirreLSQL.app/Contents/Resources/Java/lib/)
    • Open Squirrel SQL
    • 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

@ItsAncientCoder
Copy link

Helped. Thank you.

Happy Coding.

@danielsbezerra
Copy link

Great!

@victorluissantos
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment