Updating SQL server password using Infor LTR Manager

Starting with the 2025.06 version of Infor LTR, you can update your SQL server password through Infor LTR Manager.
Note: The procedure is only for updating the password for the SQL account currently in use. You cannot use this procedure to update the password to a different SQL account.

Before updating the SQL server password, you must stop all services that depend on the database:

  • Active Directory Federation Services (ADFS)
    Note: Stopping the ADFS services is not required for STS security deployments of Infor LTR.
  • Grid and grid–related applications

    Run StopAllHosts.cmd located in the <ApplicationDirectory>\InforTechStackGrid\bin folder.

  • Specific Windows services

    Stop these services on the primary node server:

    • Infor_LTR_DATACATALOG_Service
    • Infor_LTR_GraphDB_Service
    • Infor_LTR_IFS_Timer_Service
    • Infor_LTR_IFSBackground_Service
    • Infor_LTR_Notification_Service
    • Infor_LTR_Search_Migration_Service
    • Infor_LTR_Shredder_Service
    • Infor_LTR_Timer_Service
    • Infor_LTR_IONAPI_Metadata_Indexing_Service

    Stop these services on the secondary node:

    • Infor_LTR_DATACATALOG_Service
    • Infor_LTR_IONAPI_Metadata_Indexing_Service
    • Infor_LTR_Notification_Service
    • Infor_LTR_Search_Migration_Service
    • Infor_LTR_Timer_Service

After all necessary services are stopped, update the SQL server password on the database server.

Follow these steps on the primary node server:

  1. Go to the InforLTRManager directory on your PC.
  2. Modify the log4net.config file by changing the mode from ERROR to DEBUG in line 57.
  3. Run InforLTRManager.exe advancemode=TRUE to open Infor LTR Manager in the advanced mode.
  4. Specify the new database login credentials and the farm database.
  5. Go to the SQL Server Password Update tab and ensure that the current host matches the primary node name.
  6. Click Update the password.
  7. Click Yes in the confirmation dialog box.
  8. After the successful password update on the primary node server, follow these steps on the secondary nodes to resume database–dependent services:
    1. Perform steps from 1 through 7.
    2. Start only the ADFS service.
      Note: Steps b-d are not required for STS security deployments of Infor LTR.
    3. Re-download the identity provider PowerShell script from Infor LTR Manager.
    4. Run the downloaded script in the ADFS environment.
    5. Restart all servers in the LTR farm after all hosts are updated.
    6. Access the Infor LTR portal and verify that all applications are functioning correctly.
      If any errors occur during or after the process, review the InforLTRManager_<Date>.log file located in the C:/Program Data/Infor/LTR folder.