Installing the iWay Log Event Adapter for MS SQL on the MS SQL Server Machine

Once all the prerequisites have been met on the client machine, you can now remotely install the ApexSQL Log API on the server machine where SQL Server is installed.

  1. Ensure that the SQL Server is up and running.
  2. Execute the iwmssqlcdcsrvinstall.exe file from the server machine for each SQL Server instance that you require to read transaction records from the transaction log files.

    The iwmssqlcdcsrvinstall.exe file is located in the following directory:

    <iway_home>\etc\setup\cdc\MSSQLServer\server

    This installation utility copies the ApexSQL Log API server-side components on the SQL server machine.

  3. Use the following command structure for this installation:
    iwmssqlcdcsrvinstall <SQL
    Server name> <database> <user> <password>

    For example:

    C:\> iwmssqlcdcsrvinstall SPONUGOTI2 Northwind sa sa

Note: Visual C++ Redistributable 2005 is a prerequisite for the iWay Log Event Adapter for Microsoft SQL (MS SQL). If this is not already installed on the client and server machines, you can install it by executing the vcredist_x86.exe file, which is located in the \client or \server subdirectories.


iWay Software