Wednesday, May 9, 2012

Specifying SQL Server instance

Connecting to a SQL Server instance using jdbc drivers, you need to append ‘;instance=INSTNAME’ to the connection string like the following:

jdbc:jtds:sqlserver://<SQLServer>:<PORT>/<DBName>;instance=<SQLInstanceName>

Example:
jdbc:jtds:sqlserver://localhost:1433/mydb;instance=SQLEXPRESS