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

Document ID : KB000020003
Last Modified Date : 14/02/2018
Show Technical Document Details

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.