How to Restore Default Clarity SQL Database for Fresh Install on SQL Server 2008.

Article Id: 20003
Status: Published
Updated On: 14-02-2018 07:51
Legacy Id: TEC597468
Products:
CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , CA Identity Manager , CA Identity Governance , CA Identity Portal , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , Clarity PPM On Premise
Issue/Introduction:

Description:

Please follow these instructions to restore the default SQL Server database for Clarity 13.x

Solution:

  1. Login to SQL Server
  2. Right Click on Databases and select 'New Database'
  3. Provide a database name and the Account that owns the database.
  4. Click 'OK'
  5. Click on 'New Query'
  6. Select the 'Master' database.
  7. Paste the following query into the query window:

    RESTORE DATABASE 'Database_Name'
    FROM DISK = 'Path to database backup'
    WITH REPLACE

    ( You will need to enter values for the 'Database_Name' and 'Path to database backup'.)

    The default path for the database backup is ''D:\Databases\mssql_base.db'

After this is completed please follow these steps:

  1. Login to SQL Server.
  2. Click the '+' symbol to expand the 'Security' folder.
  3. Right Click on 'Logins' and select 'New Login'
  4. Enter a username.
  5. Select 'SQL Server Authentication'
  6. Assign password to account.
  7. Click 'OK'.
  8. This account will be used in the 'CSA' to access the Clarity database.

Environment:

Release:
Component: PPMENV