This procedure consists of two main parts:
...
You need to change the password of the user account created to connect to the database. This is done in MSSMS Microsoft SSMS as follows:
1- Connect to your server.
...
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 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
| Code Block |
|---|
<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> |
...
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
| Code Block |
|---|
<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
...
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
| Code Block |
|---|
<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> |
...
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
| Code Block |
|---|
<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> |
...
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
| Code Block |
|---|
<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> |
...
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
| Code Block |
|---|
<db connStr="Provider=SQLOLEDB; Data Source=sql-server,1433; Initial Catalog=AdminPortal; User ID=adminportaluser; Password=1234" cursorType="adUseServer" /> |
...
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
| Code Block |
|---|
<add key="ConnectionString" value="Data Source=[SQLSERVER];Initial Catalog=[DataBaseName];Persist Security Info=True;User ID=[username];Password=[password];Application Name=ServiceAgent" /> |
...
| Info |
|---|
The |
...