Page Comparison

...

1. In the start menu, click Programs and launch Microsoft SQL Server 20052012.
2. Click Configuration Tools, and then click SQL Server Configuration Manager.
3. Enable TCP/IP and disable Named Pipes from protocols of your Microsoft SQL server.
4. Double click TCP/IP to open the TCP/IP properties window, and set Listen All to Yes on the Protocol tab.

5. On the IP Address tab, disable TCP Dynamic Ports by leaving it blank and give a valid TCP port, so that Microsoft SQL server will listen on that port.

   Info
   The best practice is to use port 1433, because you can use it in order processing services.

6. Similarly, enable TCP/IP from SQL Native Client Configuration and disable Named Pipes. Also check whether the port is set correctly to 1433.
7. Restart Microsoft SQL Server.

...

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 and copy the following drivers to the WSO2 product's <MB_HOME>/repository/components/lib/ directory.

• The Microsoft SQL JDBC driver file jtds-1.3.1.jar.

• The Microsoft JDBC Driver 6.0, 4.2

...

• , 4.1, or 4.0.

  Note
  Sqljdbc.jar requires a JRE of 5 and supports the JDBC 3.0 API Sqljdbc4.jar requires a JRE of 6 and supports the JDBC 4.0 API Sqljdbc41.jar requires a JRE of 7 and supports the JDBC 4.1 API Sqljdbc42.jar requires a JRE of 8 and supports the JDBC 4.2 API

Setting up datasource configurations

...