Mounting WSO2 instances on a MS SQL Database which is secured via Windows authentication

A multi instance deployment of WSO2 products would require the registry (config and governance) space to be mounted on an external database.  WSO2 Products can be mounted on many types of databases. Below instructions explain how WSO2 products can be mounted on a MS SQL database that is secured via Windows Authentication.

1. download jTDS from the following link

http://sourceforge.net/projects/jtds/files/jtds/1.2.2/

2. Extract the folder and copy the jtds-1.2.2.Jar file to the {WSO2 Product}/components/lib folder

3. The extracted folder also includes ntlmauth.dll file in the \x64\SSO folder copy the dll file to java bin folder(C:\Program Files\Java\jre7\bin)

4. download and install the jdbc driver for mssql from the following location 

http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx

5. Once this is installed set the class path to the following location {JDBC driver Installation Path}\sqljdbc_4.0\enu\auth\x86

6. Make sure that the IP and the port is enabled at the MSSQL side, this can be verified through telnet.

7. Change the datasources.xml to the following configuration (Please change the DB name and the hostname accordingly)

<datasource>

<name>WSO2_CARBON_DB</name>

<description>The datasource used for registry and user manager</description>

<jndiConfig>

   <name>jdbc/WSO2CarbonDB</name>

</jndiConfig>

<definition type="RDBMS">

   <configuration>

<url>jdbc:jtds:sqlserver://localhost:1433/testDB;integratedSecurity=true;</url>

<driverClassName>net.sourceforge.jtds.jdbc.Driver</driverClassName>

<maxActive>80</maxActive>

<maxWait>60000</maxWait>

<minIdle>5</minIdle>

<testOnBorrow>true</testOnBorrow>

<validationQuery>SELECT 1</validationQuery>

<validationInterval>30000</validationInterval>

   </configuration>

</definition>

</datasource>

8. Start the ESB.