How to re-create Critical System Protection (CSP) 8.0.2 database login account on SQL Server

Products

• Critical System Protection
• Embedded Security Critical System Protection

Issue/Introduction

You have a requirement to re-create Critical System Protection (CSP) SQL database login account

Environment

CSP 8.0.2

Cause

• You cannot use local SQL accounts and need to switch to Windows Domain Authentication on your SQL database server 
• Accidental deletion of SCSPDBA login

Resolution

By default Critical System Protection (CSP) uses SCSPDBA local SQL login to connect to SCSPDB database

To recreate CSP database login on the SQL Server please follow the steps below:

#1 Open SQL Management Studio and navigate to Security -->Logins

#2 Right Click on Logins and choose New Login

#3 Choose SQL Server Authentication or Windows Authentication depending on the use case. 

#4 Set New Login password

#5 Enable Enforce password policy

#6 Disable Enforce password expiration 

#7 Set default database to SCSPDB

#8 Set default language to us_english

#9 Navigate to Server Roles and make sure it is set to public

#10 Navigate to User Mapping and assign db_owner role

#11 Navigate to Securables and confirm Explicit permission Connect SQL ad Effective permission View ANY DATABASE are granted 

#12 Under Account status confirm Login is enabled and Permission to connect to database engine is granted