This knowledge base article explains how to change the SQL database connection string used in App portal.
In some circumstances, users may want to update the database connection string after installation, for example, when specifying failover parameter. Currently, App Portal UI doesn't provide users with a method to edit the connection string. Please follow the steps below to update the connection string.
Step One: Update connection strings stored in the following files. You may see multiple connection strings in a file. Please update all in that case.
C:\Program Files (x86)\Flexera Software\App Portal\Service\ESDService.exe.config
C:\Program Files (x86)\Flexera Software\App Portal\Web\web.config
C:\Program Files (x86)\Flexera Software\App Portal\APM\Web.config
C:\Program Files (x86)\Flexera Software\App Portal\Utilities\MyApps\AppPortal.App.MyAppsExecutables.exe.config
Step Two:
Restart IIS followed by restarting the windows service called ESDService.
The result:
You can see the updated result as the sample screenshot below:
In general, connection string is case-insensitive. However, it is reported that several keywords are actually case-sensitive.
The "Failover" keyword is one of them and it is case-sensitive.
https://stackoverflow.com/questions/17306520/sql-server-connection-string-keywords-act-as-case-sensitive-although-they-should
on Oct 18, 2018 07:45 PM - edited on Dec 29, 2020 12:05 PM by dpiarowski