jTDS connection string: connect to a MS SQL Server instance with a backslash

sql-server jdbc jtds

curious1 · Oct 24, 2013 · Viewed 42k times · Source

I am using the jTDS driver in a Java application. The database administrator told me that the SQL Server instance name is

MSSQL-DB09v1\v1

How should I write the connection URL?

I have been using something like

jdbc:jtds:sqlserver://server-name/database_name

for some time and it works well, but don't know the right connection string when the instance name contains a backslash.

Answer

Did further research and tests. Found out the correct connection URL string in this case is:

jdbc:jtds:sqlserver://server-name/database_name;instance=instance_name

In my case, the connection string is:

jdbc:jtds:sqlserver://server-name/MSSQL-DB09v1;instance=v1

See jTDS FAQs for more details