1. Introduction
    1. System Requirements
    2. Setup and Installation
  2. Getting Started
    1. Creating a Database
    2. Email Configuration
    3. Web Module Setup
    4. Web Module Update
  3. Navigating RM Studio
    1. Main Menu
      1. Save Function
      2. Import External Data
        1. Import Assets
      3. Clear User Cache
      4. Security
      5. Properties
      6. Languages
      7. Registration
      8. User Manual
      9. Manage Checkouts
      10. About
      11. Application Style
    2. Navigation Tree
    3. Tabs
    4. The Grid
    5. Context & Flow
  4. Common Entities
    1. Business Entities
      1. Asset Details - Basic Information tab
      2. Asset Details - Risks tab
      3. Asset Details - Categories tab
      4. Asset Details - Business Entities tab
    2. Contacts
    3. Teams
    4. Assets
    5. Asset Categories
    6. Asset Attributes
    7. Threats
    8. Standards/Controls
      1. How to: Standards, Regulations, Controls
      2. Standards Implementation Comparison
    9. Documents
  5. Gap Analysis
    1. How to: Gap Analysis
    2. Reporting
  6. Risk Assessment
    1. How to: Risk Assessment
      1. Risk Assessment Overview
      2. Adding Assets
      3. Adding Risks
      4. Evaluation Values
      5. Evaluating Risks
      6. Various Definitions
      7. Risk Assessment Reporting
    2. Risk Owner Tasks
    3. Risk Profile
  7. Web Module
    1. Dashboard
    2. My Tasks
    3. Reports
    4. Standards/Regulations
    5. Documents
    6. Incidents
    7. Risk Owner Web Solution
  8. Control Assessment
    1. Control Assessment Templates
    2. Control Assessment
    3. Reports - Control Assessment
  9. Risk Treatment
    1. How to: Risk Treatment
      1. Risk Treatment Templates
      2. Risk Criteria
      3. Asset Level
      4. Controls Tab
      5. Scheduling a Future Control
      6. Future Controls Tab
      7. Overview
      8. Reload Assets, Threats and Controls
    2. Risk Treatment Reports
  10. STPA
    1. STPA Projects
    2. Models and Diagrams
      1. How to: Create CS Models
      2. How to: Create CS Diagram
        1. Diagram Elements
        2. Models Progress Check
    3. Analyses
      1. How to: Define Purpose of Analysis
      2. Losses
      3. Hazards
      4. Relationship
      5. Constraints
      6. How to: Identify UCAs
      7. How to: Identify Loss Scenarios
        1. Loss Scenario Progress Check
    4. Reporting
    5. Global Properties
  11. Business Continuity Management Module
    1. Organization
      1. New Organization
      2. Stakeholders
      3. Resources/Processes
        1. Impact Analysis
        2. Requirements
    2. Incident Response/Recovery
      1. Associated Threats
      2. Plans
        1. Steps
      3. Maintenance
        1. Test plans
        2. Test Results
    3. Templates
    4. Maintenance
    5. Reports BCM
  12. Database Settings
    1. Database Upgrade
    2. Add Existing
    3. Remove
    4. Migrate
    5. Backup
    6. Restore
  13. Glossary
  14. Calculations

2.1.Creating a Database

How to get started:

  1. In the login window click the ‘Settings’ button to enter the database management wizard.Database settings
  2. In the Database Settings window, click the ‘Create’ button to open the New Database Server window.Create new database
  3. In the New Database Server window enter a name (used in RM Studio) for the database under the Required Information.
    *Remember that the database names, usernames, and passwords are case sensitive in RM Studio.
  4. Enter the name for the database on your server. It is not required to have the same name for the database, because the Database Name is for your reference on your servers only.
  5. Choose where the database is stored, locally on the PC you are using, or on the designated server. If you intend to share the database with other users, you must select a server that each user has access to. Check with the appropriate IT personnel to adjust the server permissions for each RM Studio user to a DB_Owner.
  6. Choose to use the Windows Authentication for the login (recommended for higher security) or choose to create RM Studio user logins in the Common > Contacts of the main program and assign specific roles, such as, Admin, Super User, etc. (more info under Contacts section).
  7. The new database automatically creates an Administrator login that you need to assign a password to. The Administrator is also created as a default Contact in the main program for you, but you can assign other RM Studio Users/Contacts the Admin role. The Administrator account is vital for the administration of the database.

Creating database

Exception – upgrading from a previous version of RM Studio and connecting the database to the new version. Because the Administrator account is tied to the database when created, the Administrator password should have been changed when the previous RM Studio installation was used to create the database.

If you receive the error below, then you are not authorized to create the database on the server you selected. Please contact the appropriate person responsible for the server administration in your organization.

Error deploying database

Once your database is created a green ’check mark’ icon appears next to the ‘Test’ button. Click the ‘Check’ button and allow a a few seconds to check the database connection. Once the action is complete you will see a green number  to the right of the button and the word ‘Upgraded’ in green.

upgrade database version

Click ‘OK’ to complete the database setup.

If for any reason you are experiencing difficulties or are unable to complete the installation, please contact support@riskmanagementstudio.com.

Suggest Edit