Article Number | 000038009 |
Applies To | RSA Product Set: Archer |
Issue | The customer has moved the Archer databases to a new server and needs to update the services to point to the new location When opening Archer Control Panel, you get "Error communicating with the Configuration service"
 |
Resolution | If you need to update the connection string for the Configuration Database:
- Stop the Configuration Service on the server
- Open ArcherTech.Services.ConfigurationService.exe.config (by default this is located in C:\Program Files\RSA Archer\Services)
- Locate the <connectionStrings> section and update the following:
<add name="SqlDB" connectionString="Data Source=oldserver;Initial Catalog=oldDBName;User ID=olduserID;Password=oldPassword" to this: <add name="SqlDB" connectionString="Data Source=newserver;Initial Catalog=newDBName;User ID=newuserID;Password=newPassword"
If you are troubleshooting a Connection Failure from ACP:
- Verify that the Configuration Service is running on the server
- Try restarting the Configuration Service
- Open ArcherTech.Services.ConfigurationService.exe.config (by default this is located in C:\Program Files\RSA Archer\Services)
- Verify that the information listed in <connectionStrings> is correct
- Test connecting to the listed Datasource with the User ID listed and verify that the account has db_owner access to the Archer Configuration DB
- Try clearing the encrypted Password and re-entering the current password in plaintext.
Example: <connectionStrings> <add name="SqlDB" connectionString="Data Source=all.archer.local;Initial Catalog=archerconfig;User ID=archerdba;Password="MDQ0S92slPgh2P65KroO5vCEItdEBIDgBR2o0awvurXWpo4=8SEvELiTVaqbPpAYGm8eZDbyrlGQb5+1HbE79PblcytZTVaqXyinhMfUaONAXsAOtASSYsaTeoGCevIHW"" providerName="System.Data.SqlClient" /> <connectionStrings>
updated to: <connectionStrings> <add name="SqlDB" connectionString="Data Source=all.archer.local;Initial Catalog=archerconfig;User ID=archerdba;Password=updatedPassword" providerName="System.Data.SqlClient" /> </connectionStrings> - Save the file and restart the Configuration Service. After the service is restarted, the password will be re-encrypted.
|
Notes | If you wish to use Integrated Security for your Configuration DB connection, the connectionString should look like the example below: <connectionStrings> <add name="SqlDB" connectionString="Data Source=ALL;Initial Catalog=archerconfig;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings>
This will use the account that is running the RSA Archer Configuration service to connect to the database. This must be a network account with db_owner privileges on the Configuration Database. |