JIRA 4.0 : Connecting to named instances in SQL Server
This page last changed on Nov 14, 2006 by rosie@atlassian.com.
When using named instances you will need to specify the URL slightly differently in the connection properties. First off, try: url="jdbc:jtds:<server_type>://<server>[:<port>][/<database>];instance=<instance_name>" This is specified at the JTDS FAQ If this doesn't work, try dropping the instance name, and changing the port to the port used by the named instance: url="jdbc:jtds:<server_type>://<server>[:<instance_port>][/<database>]" Note. This port is different to the normal SQL Server port as each instance listens on a different port. |
![]() |
Document generated by Confluence on Oct 06, 2009 00:26 |