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.

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

  • Active Directory Federation Services (ADFS)
  • 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_Mingle_DATACATALOG_Service
    • Infor_Mingle_GraphDB_Service
    • Infor_Federation_Services_TimerService
    • Infor_Mingle_IFSBackground_Service
    • Infor_Mingle_Notification_Service
    • Infor_Search_Migration_Service
    • Infor_Mingle_Shredder
    • Infor_Mingle_Timer_Service
    • Infor_Mingle_IONAPI_Metadata_Indexing_Service

    Stop these services on the secondary node:

    • Infor_Mingle_DATACATALOG_Service
    • Infor_Mingle_IONAPI_Metadata_Indexing_Service
    • Infor_Mingle_Notification_Service
    • Infor_Search_Migration_Service
    • Infor_Mingle_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.
    3. Re-download and run a relying party trust (RPT) for the identity provider in the ADFS environment.
    4. Start the application 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.