SQL Server connection string for Mirth

You can use the following format to build a connection string for named SQL Server instance:

jdbc:jtds:sqlserver://ComputerName/DatabaseName;instance=InstanceName

Where Computer name is the name of computer on which SQL Server installed, it can be DNS or IP address.

Database name is the name of database to which you want to connect.

Instance Name is the name of the SQL Server instance.

Example

jdbc:jtds:sqlserver://mydevpc/labsystem;instance=DEVSQL01
Comments
Share it