How to move the TNGDB from one SQL2005 Server to another SQL2005 Server?

Products

• CA Security Command Center
• CA Data Protection (DataMinder)
• CA User Activity Reporting

Issue/Introduction

Description

This document describes how to move the TNGDB used by eTrust Security Command Center from one SQL 2005 Server to another SQL 2005 Server.

It is NOT recommended to move the Audit/Security Command Center Databases, however, it is possible.

It is recommended to run this is a test environment first and check for difficulties before running it in production.

Solution

IMPORTANT: This article contains information about modifying the registry.
Before you modify the registry, make sure to create back up of the registry and ensure that you understand how to restore the registry if a problem may occur.
For more information about how to back up, restore, and edit the registry, please review the relevant Microsoft Knowledge Base articles on support.microsoft.com.

1. On the SCC server, Stop the eTrust World Service and the CA-Unicenter TNG Severity Propagation Service
   
   
2. On the Source SQL 2005 Server :
   
   
   1. Open the "Microsoft SQL Server Management Studio" , expand "Databases"
      
      
   2. Right Click the TNGDB database, and select Tasks
      
      
   3. Perform a Full Backup of the TNGDB Database
      
      
3. Copy over the backup file ( .bak ) to a disk drive on the Target SQL 2005 Server
   
   
4. On the Target SQL 2005 Server, Open the "Microsoft SQL Server Management Studio"
   
   
   1. Expand Databases and Create a new TNGDB database.
      
      
   2. Expand Security / Logins and create 2 new Logins:
      
      
      - tng
      - tngsa
      
      
      For security reasons the default passwords are not documented here. Please contact ca Support for the default passwords if you don't know them.
      
      Make sure that the checkbox "User must change password at next login" is unchecked for both users.
      
      
   3. Right Click the new TNGDB Database, select task, restore Database
      
      
      • for the Restore Source, select the backup file created previously
        
        
      • in the Restore options, specify "Overwrite the existing database"
        
        
   4. Perform the Restore.
      
      
   5. Click on New Query, and Select the TNGDB database.
      
      
   6. In the Query Area, enter the command :

      sp_change_users_login 'Auto_fix', 'tng';

      and execute the query.
      
      
   7. In the Query Area, enter the command :

      sp_changedbowner 'tngsa';

      and execute the query;
      
      
5. On the SCC Server, open the registry and change the following registry value to reflect the hostname of the new Repository Server :
   
   HKLM\Software\ComputerAssociates\eTrust Common Services\TNG_REPOSITORY_SERVER
   
   
6. On the SCC Server, run odbcad32.exe and edit the TNGDB DSN ODBC connection (located under the User tab NOT the System tab) and enter the new Server Name.
   
   
7. Restart the eTrust World Service and the CA-Unicenter TNG Severity Propagation Service.

Environment

Release:
Component: ETRSCC