Configuring SQL Server databases for HCL SafeLinx with DDL

This task describes how to use DDL scripts to create the HCL SafeLinx session and accounting databases on SQL Server. When you use DDL scripts to create or update SafeLinx databases on SQL Server, do not run the Database configuration wizard. SQL Server databases are supported for deployments in which the SafeLinx Server is installed on Windows only.

About this task

SQL Server databases are supported for use with Windows deployments of the Connection Manager only.

Procedure

  1. Copy the DDL scripts to the database server.
  2. Edit the script to customize the location of files, size of the database, schema names, and so forth.
  3. Apply the DDL schema to the session database. From a command prompt, type the following command: sqlcmd -U admin_ID -P admin_ID_pwd -i "wgdata-create.sql" -v filepath="path_to_db" password="wgdb_user_pwd"
  4. Optional: Create the accounting database. From a command prompt, type the following command: sqlcmd -U admin_ID -P admin_ID_pwd -i "wgacct-create.sql" -v filepath="path_to_db" password="wgdb_user_password"
  5. Grant the wgdb user ID permission to use the HCL SafeLinx database. From a command prompt, type the following command: sqlcmd -U admin_ID -P admin_ID_pwd -i "wgdata-grant.sql"
  6. If you created a wgacct database, run the script to grant the wgdb user ID permission to use it. From a command prompt, type the following command: sqlcmd -U admin_ID -P admin_ID_pwd -i "wgacct-grant.sql"
  7. Copy the file <Installation_directory>\Connection Manager\conf\SQL\wg.mssqldb.al to the Installation_directory\SafeLinx Server\conf directory.
  8. Using a text editor, open the wgdbms.conf.template file in the directory <Installation_directory>\SafeLinx Server\conf. Using the comments in the file as a guide, edit the values in the file and then save it in the same directory as wgdbms.conf.
    You are now ready to run the SafeLinx Administrator and configure your SafeLinx Server.