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 MSSMS 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 descried 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.
<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.
<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
Windows 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.
<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.
<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" /> </connectionStrings>
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.
<connectionStrings> <add name="AccessPortalEntities" connectionString="data source=SERVER-NAME;initial catalog=AccessPortal;user id=AccessPortalUser;password=USER-PASSWORD;multipleactiveresultsets=True;application name=MNTS" 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=MNTS" providerName="System.Data.SqlClient" /> </connectionStrings>
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.
<db connStr="Provider=SQLOLEDB; Data Source=sql-server,1433; Initial Catalog=AdminPortal; User ID=adminportaluser; Password=1234" cursorType="adUseServer" />
d- Start the service
5- Service Agent
You could have multiple of these services, and each one of the services above could have one of these services which is intended to monitor the main service.
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.
<add key="ConnectionString" value="Data Source=[SQLSERVER];Initial Catalog=[DataBaseName];Persist Security Info=True;User ID=[username];Password=[password];Application Name=ServiceAgent" />
d- Start the service
Tips
The "AccessPortalFilesEntities" in the connection string above is used only if you have second database ends with “files”, If you don’t you just use "AccessPortalEntities".
There are four things to fill in the connection string:
1- Data Source = (DB Server)
2-Initial Catalog= (DatabaseName)
3- ID=(user account created to connect to the database)
4-Password=(The password of the above account which you just changed)