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 or Linux server machine before you install Database Connectors for MSSQL on the client machine. Follow the installation instructions from the vendor.

  2. Copy ms_inst.cmd (Windows) or ms_inst.sh (Linux/UNIX) from the install (Windows), or /src/mssql (Linux/UNIX) sub-directory of your Micro Focus product installation directory to a directory on the server.

    This 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 one of the appropriate database tools (such as SQL Query Analyzer or the SQL Server Management Studio on Windows, or the SQL Server command-line tools on Linux).

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

This completes the setup on the server machine.

Note: If you are updating from an earlier version of Database Connectors, be sure to install the new stored procedures. Stored procedures are always updated 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.