Creating the Studio database

Before creating the database for Studio you must:

  1. Create the following users and assign them the required privileges.
    Database user Function Create user on Permissions
    User 1 Create and configure Studio database SQL Server The dbcreator role assigned to User 1.

    Select MSDB as the default database when creating or configuring the Studio database.

  2. Provide the following details on the database configuration screen:
    Database Server
    Provide the name of the server hosting the database.
    By default, the name displayed is .\SQLEXPRESS. This name can be modified as required. This can be a local database or a database located on a remote server.
    Database Name
    Provide the database name. By default, it is StudioDB but can be edited.
    SQL Server Credentials
    Select an authentication to create and access the database and the credentials required:
    • If you select Integrated Authentication, Studio will use the currently logged in user credentials to access the database.
    • If you select SQL Authentication, the User Name and Password fields are enabled. Provide the credentials of the user creating the database.
  3. Click Yes on the confirmation message displayed.
    Note: After you have created the Studio database, you must add users to the Studio Installation folder and give them full permission. These users can then install Studio and even use Studio.
  4. To add users and provide them full permission:
    1. Right click the Studio folder (C:\Program Files\Approva Studio) to display the Studio Properties screen .
    2. On the Security tab, add user names and provide full permissions.