System Administration

Page tree

Versions Compared

Old Version 9

changes.mady.by.user Unknown User (beth.luby)

Saved on

compared with

New Version 10

changes.mady.by.user Unknown User (devinlong)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. While the 

    Companyname
     installer is running, and at the stage of asking for the MS SQL credentials, navigate to the Agiloft\resources\resources.zip\resources\java\lib\mssqlxa directory and open the files inside your zip viewer. 

    1. Copy the sqljdbc_xa.dll file from the directory to the Binn directory of the SQL Server computer.

      Note: For a default SQL Server install, the location is C:\Program Files\Microsoft SQL Server\<MSSQLSERVER>MSSQL14.MSSQLSERVER\DTSMSSQL\Binn.

    2. Run the xa_install.sql database script from the directory:
    3. In the command prompt, enter sqlcmd -i xa_install.sql. This script installs the extended stored procedures that are called by sqljdbc_xa.dll. These extended stored procedures implement distributed transaction and XA support for the Microsoft SQL Server JDBC Driver. You will need to run this script as an administrator of the SQL Server instance. You can ignore errors about being unable to drop procedures that don't exist.
  2. Change the password and database name (sw2_std) if needed in the aluser.sql script and run it the same way as xa_install.sql. The script creates an 
    Companyname
     user with SysAdmin role and the ability to use XA Transactions. For best results, do not revoke the SysAdmin role for this user.
  3. Close the SQL Server Management Studio. If this is not closed, the 
    Companyname
     installer will not be able to get an exclusive lock to set the database options, and will wait forever. 
  4. Continue with the 
    Companyname
     installation. 

...