Configuring the SQL Server
![*](icon_task_xpe.png)
To use an SQL 7.x database as the message store, configure the SQL Server as follows
1. Create a user account that the Partner Manager can use to access the database.
2. Create a user-defined data type named Date that has the data type “datetime.”
3. Create the following tables and give the Partner Manager’s account read/write access to them.
Table | Columns | Type | Length |
WMTRANSACTION_Log | tid | VARCHAR | 50 |
creationdate | DATE | |
message | VARCHAR | 255 |
WMTransactions | tid | VARCHAR | 50 |
sender | VARCHAR | 50 |
receiver | VARCHAR | 50 |
msgType | VARCHAR | 50 |
package | VARCHAR | 50 |
docURI | VARCHAR | 50 |
flow | VARCHAR | 50 |
lastError | VARCHAR | 50 |
state | INTEGER | |
wmTime | DATE | |
Note:
If you grant the Partner Manager’s user account permission to create tables, the Partner Manager will automatically create these tables for you the first time it connects to the database.