000038009 - Update the RSA Archer Configuration Service Database Connection

If you need to update the connection string for the Configuration Database:

1. Stop the Configuration Service on the server
2. Open ArcherTech.Services.ConfigurationService.exe.config (by default this is located in C:\Program Files\RSA Archer\Services)
3. 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"
    

   
   

1. Verify that the Configuration Service is running on the server
2. Try restarting the Configuration Service
3. Open ArcherTech.Services.ConfigurationService.exe.config (by default this is located in C:\Program Files\RSA Archer\Services)
4. Verify that the information listed in <connectionStrings> is correct
5. 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
6. 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=&quot;MDQ0S92slPgh2P65KroO5vCEItdEBIDgBR2o0awvurXWpo4=8SEvELiTVaqbPpAYGm8eZDbyrlGQb5+1HbE79PblcytZTVaqXyinhMfUaONAXsAOtASSYsaTeoGCevIHW&quot;" 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>
    

   
   
7. Save the file and restart the Configuration Service. After the service is restarted, the password will be re-encrypted.