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 1433port1433,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  Also check whether the port is set correctly to 1433.
7. Restart Microsoft SQL Server.

...

Assign newly created users the required grants/permissions to log in, create tables, and insert, index, select, update, and delete data in tables in the newly created database, as the minimum set of SQL server permissions. 

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

• Download the Microsoft SQL JDBC driver file jtds-1.3.1.jar and copy it to the lib directory.

• 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 lib directory:

  Note
  If you are using JRE 7, install the Sqljdbc41.jar file. This supports the JDBC 4.1 API. If you are using JRE 8, install the Sqljdbc42.jar file. This supports the JDBC 4.2. API.

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. 

...