...
- Download the Microsoft SQL JDBC driver file
jtds-1.3.1.jarand copy it to thelibdirectory. Download the Microsoft JDBC Driver 6.0, 4.2, 4.1, or 4.0 and copy the JAR file that is compatible with your JRE version to the
libdirectory:Note - If you are using JRE 7, install the
Sqljdbc41.jarfile. This supports the JDBC 4.1 API. - If you are using JRE 8, install the
Sqljdbc42.jarfile. This supports the JDBC 4.2. API.
- If you are using JRE 7, install the
Step 2: Connecting the server to the MSSQL database
Once you have setup the physical database as explained in the previous step, the next step is to enable the connectivity between your MB server and the database. This can be done by simply copying the relevant database drivers to your server, and then configuring the datasources in MB to link to the new database. See the instructions given below.
Copying the JDBC driver
Download and copy the Microsoft SQL JDBC driver file jtds-1.2.2.jar to the WSO2 product's <MB_HOME>/repository/components/lib/ directory.
Setting up datasource configurations
...