How to Change the Maintenance Service Database connection string?

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: