The following information is Copyright OpenText.
MESSAGEmanager uses SQL databases to store all inbound and outbound messages. Following are the MESSAGEmanager databases which, by default, are installed on the local SQL server.
All databases can be stored on a local or network SQL server. It is recommended that the queues are stored locally unless using multiple servers for failover and redundancy (where a working server can take over the messages from a failed server). This is because messages will fail if the send or recv databases go offline, whereas MESSAGEmanager will continue to operate as normal if the archive database goes offline and will update it when the connection is restored.
MESSAGEmanager installation assumes a local SQL server. If using a remote SQL server, you will need to create the databases using the scripts below and install MESSAGEmanager without a SQL database.
If manually creating the MESSAGEmanager databases before or after installation (to relocate the data), run the appropriate SQL script CreateDatabase.sql. The script can be customized to modify the default database name and table names. The database name is configurable from the MESSAGEmanager MMC Management Tools but the table names require registry changes.
Following are the locations for each of the CreateDatabase.sql file for each database, although all scripts can also be downloaded from the attachment provided with this Knowledge Base Article.
In the installation folder:
%Program Files%\MESSAGEmanager Solutions\MESSAGEmanager\nnnnn
where nnnnn=database name as per above list.
Note that the Web Client CreateDatabase script is installed as part of the Web Client and not the Server. For the Web Client, you must also run these other scripts after the database has been created:
osql -S YourSqlServerName -E -d master -i CreateDatabase.sql
On full SQL, there are also the GUI Management Tools that you can use to execute the SQL file.
After the database has been created and MESSAGEmanager has been installed, you will need to configure MESSAGEmanager to point to the SQL location and database name. For example to reconfigure the FSIDrecvArchive database location, do the following.
Note: The service account that MESSAGEmanager runs under must have sysadmin or db_owner writes to the MM databases