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.

  • FSIDsend - Outbound queue of fax, SMS and e-mail messages.

  • FSIDrecv - Inbound queue of fax and SMS messages.

  • FSIDsendArchive - Archived outbound fax, SMS and email messages.

  • FSIDrecvArchive - Archived inbound fax and SMS messages.

  • FSIDdetail - FSID call detail database for enhanced reporting.

  • FSIDGateway - Optional FSID Gateway and Web Client user database.

  • FSIDWeb - Web Client database.

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:
  • Procedures.sql
  • Defaultdata.sql
On a server with any edition of MS SQL you can run the following command:

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.
  • Open the MESSAGEmanager MMC, expand MESSAGEmanager FSID, expand your server name, select Inbound Messages.
  • In the right window select the Archive tab.
  • Configure the server name and instance to reflect the SQL server, i.e servername\instancename.
  • Configure the database name if using a different name than in the script
  • Review any other changes which may be required, e.g. Message purging.
  • Apply the changes.
  • Restart the MESSAGEmanager FSID service.

Note: The service account that MESSAGEmanager runs under must have sysadmin or db_owner writes to the MM databases