Follow the instructions below to set up the MS SQL database for the Governance Registry.
...
| Table of Contents | ||||
|---|---|---|---|---|
|
...
|
...
Setup Database and User
Enable TCP/IP
...
1. Edit $GREG_HOME/repository/conf/registry.xml and give the following:
| Code Block |
|---|
<currentDBConfig>mssql-db</currentDBConfig> <dbConfig name="mssql-db"> <url>jdbc:jtds:sqlserver://10.100.3.251:1433/wso2greg</url> <url>jdbc:jtds:sqlserver://SERVER_NAME:PORT/DB_NAME</url> <userName>USER_NAME</userName> <password>PASSWORD</password> <driverName>net.sourceforge.jtds.jdbc.Driver</driverName> <maxActive>80</maxActive> <maxWait>60000</maxWait> <minIdle>5</minIdle> </dbConfig> |
2. Edit $GREG_HOME/repository/conf/user-mgt.xml and give the following:
| Code Block |
|---|
<Configuration>
...
<Property name="url">jdbc:jtds:sqlserver://SERVER_NAME:PORT/DB_NAME</Property>
<Property name="userName">USER_NAME</Property>
<Property name="password">PASSWORD</Property>
<Property name="driverName">net.sourceforge.jtds.jdbc.Driver</Property>
<Property name="maxActive">50</Property>
<Property name="maxWait">60000</Property>
<Property name="minIdle">5</Property>
</Configuration>
|
...
| Info | ||
|---|---|---|
| ||
JDBC driver can be downloaded from http://jtds.sourceforge.net/projects/jtds/files/ |
...
Create Database Tables
Database tables can be created either manually by running scripts or automatically by using start-up parameters.
...
Linux users should use $GREG_HOME/bin/wso2server.sh -Dsetup.
| Excerpt | ||
|---|---|---|
| ||
Instructions on how to set up Governance Registry with MS SQL database. |