How to migrate the CCS AM database to another SQL instance

book

Article ID: 178888

calendar_today

Updated On:

Products

Control Compliance Suite Assessment Manager

Issue/Introduction

 

Resolution

  1. Make a backup of the existing DB following HOWTO125151.  Do not restart the CCS Assessment Manager service.
  2. Move the backup to the new instance of SQL.
  3. In the MS SQL Management Studio go to security and then logins, selecting the CCS AM account. If the account does not exist add it by right clicking on the Logins folder and selecting New Login.
  4. Open the account properties, select Server Roles and make sure that public and sysadmin are selected.  Select the User Mapping section and make sure the CCSAM_DB* is selected and make sure that User and Default Schema have dbo listed.  Additionally make sure that the database membership mapping has db_owner and public selected and then click OK.
  5. Go to the host machine for CCS AM and browse to <install directory>\Program Files (x86)\Symantec\CCS Assessment Manager\CCS Assessment Manager Server\Application Server directory and open the RAMServer.exe.config file with a text editor.
  6. Find the line <add key="ConnectionString" value="Data Source=<SQL HOST MACHINE NAME>;Initial Catalog=CCSAM_DB;Integrated Security=True;Encrypt=False;Max Pool Size=500;Pooling=True;" /> and replace the text in bold with the SQL host machine (short) name and then save the file.
  7. Open regedit and go to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Symantec\ResponseAssessmentServer\RAMServer.  Locate the key DBServer on the right and right click it and select modify.  Change the Value data to the new SQL machine short name and click OK.
  8. Go to Services on the AM host machine and start the CCS Assessment Manager service.

The CCS AM console will open as normal.

 *Note: The database may be named CCSAM_DB or RAM_Db depending on the version of CCS AM version.