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 , CA Project & Portfolio Management , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , CA Identity Manager , CA Identity Governance , CA Identity Portal , STARTER PACK-CLARITY PPM
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