Skip to main content
Kofax

Installing KTA against SQL Azure

Applies to ..

KTA v7.5, KTA v7.6

 

Behaviour

During a KTA installation using Setup.exe, we get an error stating 'Insufficient database privileges' even though we are using the SQL Server Admin user,
Or the KTA install error log has the error "Windows logins are not supported with this version".

Known Bugs

Bug 1258903:Installation of Databases automatically on SQL azure is failing

This bug has been marked as fixed in KTA v7.7

Workaround

Manually create the following DB’s in Azure:
1.       TotalAgility
2.       TotalAgility_Documents
3.       TotalAgility_Reporting
4.       TotalAgility_Reporting_Staging
5.       TotalAgility_Simulator

On your VM, connect to the Azure server in SSMS

Navigate to the v7.5 Installation Files\TotalAgilityInstall\DatabaseScripts\SQL Server folder

Run the following scripts against the TotalAgility DB:
1.       Create_Archive
2.       Create_Audit
3.       Create_Forms
4.       Create_KFS
5.       Create_Main

When the creation scripts have all executed successfully, run the following Initialisation scripts against the TotalAgility DB:
1.       Initialise_Audit
2.       Initialise_Forms
3.       Initialise_KFS
4.       Initialise_Main

Run the following script against the TotalAgility_Simulator DB:
1.       Create_Simulator

Navigate to the v7.5 Installation Files\TotalAgilityInstall\DatabaseScripts\SQL Server\LicenseScripts folder

Run the following script against the TotalAgility DB:
1.       Create_KLS_OnPremise

Navigate to the v7.5 Installation Files\TotalAgilityInstall\DatabaseScripts\SQL Server\DataLayer folder

Run the following script against the TotalAgility_Documents DB:
1.       Repository2012_TablesCreate

Navigate to the v7.5 Installation Files\TotalAgilityInstall\DatabaseScripts\SQL Server\Reporting folder

Run the following script against the TotalAgility_Reporting DB:
1.       Kofax.Reporting.Analytics.SQL_TablesCreate
2.       Kofax.Reporting.Analytics.SQL_Initialize

Run the following script against the TotalAgility_Reporting_Staging DB:
1.       Kofax.Reporting.Analytics.Staging.SQL_TablesCreate
2.       Kofax.Reporting.Analytics.Staging.SQL_Initialize

When all of the above scripts have been successfully executed, we must now update the Sever_Data table so that the Main TotalAgility DB can communicate with the Documents DB:

Copy the connection string for TotalAgility_Documents from your Azure Portal

Replace ’NEWCONNECTIONSTRING_COPIED FROM AZURE’ with the connection string you have copied – please ensure to keep the single quotes around the connection string,

Example Azure connection string:
‘Server=tcp:servername.database.windows.net,1433;Initial Catalog=TotalAgility;Persist Security Info=False;User ID={your_username};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;’

Run the following script against the TotalAgility DB

UPDATE server_data
SET CEBPM_SETTINGS =
REPLACE(CAST(CEBPM_SETTINGS as varchar(max)), ';Data Source={DATA_LAYER_DATASOURCE};Initial Catalog=TotalAgility_Documents;User ID={DATA_LAYER_USERID};Password={DATA_LAYER_PASSWORD];Integrated Security={DATA_LAYER_WINDOWS_AUTH};Connect Timeout=30;Encrypt=False;TrustServerCertificate=False', 'NEWCONNECTIONSTRING_COPIED FROM AZURE')

Open command prompt and execute the command ‘whoami’
Copy the username and paste it into the following script in place of <<replace me>>:

UPDATE nt_resource
SET nt_name = REPLACE(nt_name, 'INSTALL_NTUSERID', '<<replace me>>'

Run the script against the TotalAgility DB

Now we can proceed with installing KTA

Choose your installation type, our example is installing a combined Web/App and continue on until the 'Databases' window

On this Window,
UNCHECK INSTALL DATABASES

We will still add our servername, username and password so that the config files are updated for us,
Click on the button with the 3 dots shown at point 2 in this screenshot
7.png

Enter the server name (can be copied from Azure Portal), username and password
Check the box to ‘Apply these settings to all other Databases’:
8.png

Ensure the server names have all successfully updated before continuing:
9.png

Continue with the remainder of the installation
Install TS if required

When the Installation has completed:
  1. Start all Kofax Services
  2. Log into designer
    • Set license if prompted
  3. Open the resource module
  4. In 'Everyone' group find the resource called INSTALL_FULLNAME
  5. Change INSTALL_FULLNAME resource name to something meaningful

Import the WorkSpace Package

  1. Navigate to the Packages module
  2. Choose Import Package
  3. Browse to C:\Program Files\Kofax\TotalAgility\Sample Processes
  4. Select Workspace package and Import it

Please run some sanity checks at this point to ensure that all services are working as expected – including TS if you are using it