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:
- Go to the InforLTRManager directory on your PC.
- Modify the log4net.config file by changing the mode from
ERROR
toDEBUG
in line 57. - Run
InforLTRManager.exe advancemode=TRUE
to open Infor LTR Manager in the advanced mode. - Specify the new database login credentials and the farm database.
- Go to the SQL Server Password Update tab and ensure that the current host matches the primary node name.
- Click .
- Click in the confirmation dialog box.
- After the successful password update on the primary node server, follow these steps on the secondary nodes to resume database–dependent services: