Squirrel SQL database client
Symptoms
Users that experience database connectivity issues in JIRA can benefit from testing the connection through a DB client such as SQuirrel SQL Client. The client allows the user to test JDBC connections as well as provide a helpful stacktrace feature to help troubleshoot issues.
Download client:
Connecting to SQL Server
Copy the bundled SQL driver from JIRA $JIRAINSTALL/lib/jtds-1.2.4.jar to your Squirrel directory: C:Documents and Settings.squirrel-sql (Windows)
The actual Squirrel path may be different depending on how it was installed.
Start up Squirrel and you should be able to see an Alias and a Drivers tab in the UI Select the Drivers tab and scroll down until you see jTDS Microsoft SQL.
If there is a blue checkmark next to it, then the driver is properly identified. If it's not there, then we need to check and make sure that the jtds-1.2.4.jar file is copied correctly into Squirrel library. Alternatively, double click to bring up the jTDS Microsoft SQL properties, and select the Extra Class Path tab.
Click Add and navigate to $JIRAINSTALL/lib/jtds-1.2.4.jar to manually add this to the class definition.
Next, navigate to the Alias tab to create a new connection to your DB. Click on the blue 'plus icon' to bring up the new alias dialog. Here we enter the connection details:
Name: Alias Name Here Driver: jTDS Microsoft SQL URL: jdbc:jtds:sqlserver://hostname:port/DB Username: username Password: password
Once configured, please click on 'Test' to verify the connection. If it fails, you can click on 'Stack Trace' to see the error that is being generated.
