How to Restore Default Clarity SQL Database for Fresh Install on SQL Server 2008.
book
Article ID: 20003
calendar_today
Updated On:
Products
Clarity PPM SaaS
Clarity PPM On Premise
Issue/Introduction
Description:
Please follow these instructions to restore the default SQL Server database for Clarity 13.x
Environment
Release:
Component: PPMENV
Resolution
Solution:
- Login to SQL Server
- Right Click on Databases and select 'New Database'
- Provide a database name and the Account that owns the database.
- Click 'OK'
- Click on 'New Query'
- Select the 'Master' database.
- 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:
- Login to SQL Server.
- Click the '+' symbol to expand the 'Security' folder.
- Right Click on 'Logins' and select 'New Login'
- Enter a username.
- Select 'SQL Server Authentication'
- Assign password to account.
- Click 'OK'.
- This account will be used in the 'CSA' to access the Clarity database.
Feedback
thumb_up
Yes
thumb_down
No