Tungsten Automation (Formerly Kofax)
      Back to home
      1. Knowledge Base and Help Center
      2. Tungsten Automation (Formerly Kofax)

      Tungsten upgrade installation is not able to connect to the existing database

      Issue:

      When upgrading the Kofax Totalagility version from 8.0 to 8.1, the issue of connecting to the existing database(SQL Server) occurred. A connection was successfully established with the SQL Server, but then an error occurred during the login process.

      Below is the error message:

      BPM Error: 1 : Fatal error Occurred when installing, application will exit Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect.) ---> System.ComponentModel.Win32Exception (0x80004005): The target principal name is incorrect
         at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)

       

      Resolution:

      The reason why the issue occurred is that the Setup.exe file in the newer version TotalAgilityInstall folder failed to find the right SQL server.

      1. Navigate to the location under:

          \\<The Folder Where TungstenTotalAgility-8.1.0 Installer Is>\\TungstenTotalAgility-8.1.0\TotalAgilityInstall

      2. Find Setup.exe.config

      3. Change the value for Server to the SQL Server Name.

      4.  Save it and run Setup.exe again.