To install Database Connectors for Microsoft SQL Server

Restriction: This topic applies only when a Database Connectors license has been installed via the Micro Focus License Management System.
Note: Your Microsoft SQL Server can be installed on a separate server, or on the same machine as your client. See the Microsoft SQL Server help for details on how to configure the relevant communications.
  1. Install a supported version of Microsoft SQL Server.

    You must install and configure Microsoft SQL Server, version 6.5 or later, on the Windows server machine before you install Database Connectors for MSSQL on the client machine. Follow the instructions from your RDBMS vendor.

  2. Copy MS_INST.CMD from the install sub-directory of your Micro Focus product installation directory to a directory on the server.

    MS_INST.CMD is the batch file supplied by Micro Focus that creates the stored procedures necessary for using Database Connectors.

  3. Execute the batch file using the following command:

    MS_INST LockDatabase

    where LockDatabase is the database you want to use for the internal lock tables; this does not need to be an existing database, as one will be created, if required, in the next step. However, you must ensure the required Database Connectors users have write access to this database.

    Executing this command produces a MS_INST.SQL file.

  4. Execute the contents of this file (MS_INST.SQL) using the SQL Query Analyzer or the SQL Server Management Studio (which depends on the version of SQL Server you have installed).

    When complete, the stored procedures necessary for the MSSQL connector are installed.

This completes the setup on the Windows server machine.

Note: If you are upgrading from an earlier version of Database Connectors, be sure to install the new stored procedures. Stored procedures are always upgraded in such a way that they are compatible with older versions of the product, so installing new stored procedures over old ones does not affect your ability to run with an older version of the interface software. Your new version of Database Connectors for MSSQL may not run properly without the corresponding stored procedures.

It can be difficult to maintain multiple copies of stored procedures; therefore, we recommend that you continue to create the stored procedures in the same database. If your installation does not permit this, you do have the flexibility to create the stored procedures elsewhere. However, to facilitate maintenance of the stored procedures, we recommend that you create as few databases as possible.