You must install and configure Microsoft SQL Server, version 6.5 or later, on the Windows or Linux server machine before you install Acu4GL for MSSQL on the client machine. Follow the installation instructions from the vendor.
This is the batch file supplied by Micro Focus that creates the stored procedures necessary for using Acu4GL.
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 Acu4GL users have write access to this database.
Executing this command produces a ms_inst.sql file.
When complete, the stored procedures necessary for the MSSQL connector are installed.
This completes the setup on the server machine.
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.