Summary
This knowledge base article explains how to change the SQL database connection string used in App portal.
Synopsis
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:
Additional Information
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
Related Articles
Backup the App Portal Database 5Number of Views App Portal DataSync error: String or binary data would be truncated 5Number of Views A semi-colon in the password in a database connection string may cause a business adapter to fail 4Number of Views An SQL data change is not permitted for a read-only connection, user, or database 7Number of Views App Portal Service Account Password Change 7Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago