How to change the database password

This procedure consists of two main parts:

Part 1

You need to change the password of the user account created to connect to the database. This is done in Microsoft SSMS as follows:

1- Connect to your server.

2- Go to Security > > Logins > > AccessPortalUser (this is the default name)

3- Right click and select Properties.

Part 2

You must change the password in the connection string of each service configuration file to connect to the database. There are two types of services as described below:

IIS services

1- SphereShield-AccessPortal (you might have named it something else)

a- Normally located in the path C:\inetpub\AccessPortal\Configuration\ConnectionStrings.config

b- Stop the service

c - This is the connection string that you can replace with the encrypted one after entering the new password value in place of USER-PASSWORD

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

d- Start the service

2- ISA (Internal Service API)

a- Normally located in the path C:\inetpub\InternalServicesAPI\configuration\connectionStrings.config

b- Stop the service

c-This is the connection string which you can replace with the encrypted one after you have filled in the new value of the password in place of USER-PASSWORD

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

d- Start the service

Other Sphereshield Services

1- Casb Adapter

a- Normally located in the path C:\Agat\CasbAdapter\Configuration\connectionStrings.config

b- Stop the service

c-This is the connection string which you can replace with the encrypted one after you have filled in the new value of the password in place of USER-PASSWORD

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

d- Start the service

2- ADSync Adapter

a- Normally located in the path C:\Agat\ADSyncAdapter\Configuration\connectionStrings.config

b- Stop the service

c-This is the connection string which you can replace with the encrypted one after you have filled in the new value of the password in place of USER-PASSWORD

d- Start the service

3-Maintenance Service

a- Normally located in the path C:\Agat\MaintenanceService\Configuration\connectionStrings.config

b- Stop the service

c-This is the connection string which you can replace with the encrypted one after you have filled in the new value of the password in place of USER-PASSWORD

d- Start the service

4- Bastion (Teams Protector)

a- Normally located in the path C:\Agat\Bastion\MSTeamsProxy\filters\fw_proxy\Teams_Protector.xml

b- Stop the service

c-This is the connection string which you can replace with the encrypted one after you have filled in the new value of the password in place of 1234

d- Start the service

5-Service Agent

You could have several of these services, and each of the above could have one of these services to monitor them.

a- Normally located in the path C:\Agat\Tools\ServiceAgent\(Service)\AgatSphereShieldServiceAgent.config

b- Stop the service

c-This is the connection string which you can replace with the encrypted one after you have filled in the new value of the password in place of password

d- Start the service

Tips

The "AccessPortalFilesEntities" in the connection string above is used only if you have a second database whose name ends with “files”, If you don’t you just use "AccessPortalEntities".

There are four things to be entered in the connection string

1- Data source = (DB server)

2- Initial catalogue= (database name)

3- ID =(User account created to connect to the database)

4- Password=(The password of the above account you just changed)