Connecting to MS SQL Server Database

Refer to Help on how to setup the SQL Server connection. Key parameters are provided below:

DB Driver object properties are:

Upload Driver: jtds-1.2.jar (upload this driver)
Driver Main Class Name: net.sourceforge.jtds.jdbc.Driver

DB Info object properties are:

Select the JDBC driver
Server URL: jdbc:jtds:sqlserver://hostname_or_IP:1433/dbname

Make sure the TCP/IP settings is Enabled.
And port 1433 is explicitly defined in the TCP/IP settings

 

SQL server with named instances

For example if your Database Name is "AdeptiaDB" and instance name is "development" then Database Name field will contain the following:

AdeptiaDB;instance=development

 

Note: Some drivers are pre-shipped with Adeptia and are located here \AdeptiaServer\ServerKernel\libs\driver

Have more questions? Submit a request

0 Comments

Article is closed for comments.