Installing Microsoft SQL Server/EMS

Use this procedure to install a Microsoft SQL database and EMS.

Procedure

  1. Install the TIBCO Enterprise Messaging Server and start the server.
  2. Install the Microsoft SQL Server Database.
    1. Download and install the Microsoft SQL Server Database.
    2. Perform the server configuration by following the prompts in the Microsoft SQL Server installer.
    3. Accept the default port value 1433, or enter your own port number.
    4. Download the following JDBC driver connector JAR files (sqljdbc4.jar) to the TIBCO_HOME/afx/version/system/lib/db folder.
    Note: The TIBCO_HOME/afx/version/config/dbscripts/sqlserver/folder contains two SQL scripts named sqlserver_create and sqlserver_drop. These scripts help you to administer the database in an efficient manner. The sqlserver_create script indicates what you can expect in the database and the sqlserver_drop script allows you to drop a table if you have a problem with the database. You should back up the data before using the sqlserver_drop script.