How to Change the Maintenance Service Database connection string?

Owned by Former user (Deleted)
Last updated: Apr 13, 2022 by Avi J. Levin (Unlicensed)

1. Rename the Maintenance Service connection strings configuration file (connectionStrings.config) located by default at:

C:\Agat\MaintenanceService\Configuration\connectionStrings.config

2.Copy the fresh configuration file from the payload, located by default at (after extracting the package):

C:\Agat\MaintenanceService\Configuration\

You can also download the ConnectionStrings.config HERE.

to the Maintenance Service configuration folder.

3. Edit the connection string. Your fresh string should look like:

<connectionStrings>
<add name="AccessPortalEntities" connectionString="data source=SERVER-NAME;initial catalog=AccessPortal;user id=AccessPortalUser;password=USER-PASSWORD;multipleactiveresultsets=True;application name=AccessPortal" providerName="System.Data.SqlClient" />
</connectionStrings>

Please note if you are using Multisubnet SQL Always-ON, your connection string should be as follows:


<connectionStrings>
<add name="AccessPortalEntities" connectionString="data source=SERVER-NAME;initial catalog=AccessPortal;user id=AccessPortalUser;password=USER-PASSWORD;MultiSubnetFailover=True;multipleactiveresultsets=True;application name=AccessPortal" providerName="System.Data.SqlClient" />
</connectionStrings>


you need to edit to following values to match your environment:

  • Data source - SQL server instance name
  • Initial catalog - Admin Portal DB name
  • User ID - Admin Portal user
  • Password - Admin Portal user's password


Important Note

The Maintenance Service encrypts the connection strings configuration file when it's being loaded up.
Your current file will look like that:

a fresh configuration file should look like: