Skip to main content

Dedicated database, user, and schema

Bravura Security Fabric requires a dedicated database, user and schema in SQL Server in order to connect to and install schema objects.

When using the Bravura Security Fabric setup installer, you can:

  • Allow setup to do this for you, when asked to enter the database connection and user information;

    Or

  • Use the following instructions to pre-configure the user and schema, then enter database server connection settings when configuring the installation.

If you choose to pre-configure the user and schema:

  1. Start Microsoft SQL Server Management Studio.

  2. Connect to the server as a system administrator (sysadmin role).

    You can do this using SQL Server authentication and the sa account, or using Windows authentication if the Windows user has the sysadmin role.

    For example, to connect to the server using the sa account, set:

    Server type: Database Engine

    Server name: <host name or IP address> \ <instance>

    Authentication: SQL authentication

    Login: sa

    Password <password for sa>

    Click Connect.

  3. Create a new database for Bravura Security Fabric :

    1. In the Object Explorer (left) pane, right-click Databases, then click New Database….

    2. Type the Database name .

    3. Click Options .

    4. Select Recovery model and choose Simple.

      Note

      Ensure that an appropriate database backup policy is in place. See http://technet.microsoft.com/en-us/library/ms189275.aspx for more information.

    5. Select Compatibility level and ensure that this is set to a minimum value of SQL Server 2014 (120).

      The compatibility level for the installed version of Microsoft SQL Server is suitable.

    6. Select Auto Create Statistics and choose True.

    7. Select Auto Update Statistics and choose True.

    8. Select Auto Update Statistics asynchronously and choose False.

    9. Click OK.

  4. Create a new login:

    1. In the Object Explorer pane, expand Security.

    2. Right-click Logins, then click New Login….

    3. On the General page, type the Login name.

    4. Select:

      • SQL Server Authentication

        Type and confirm the password for the new login. Deselect the User must change password at next login and Enforce password expiration checkboxes.

        Or

      • Windows authentication

        Pick a local or domain account or group.

    5. Set Default database to the database that you created in Step 3.

    6. Click OK.

  5. Create a new schema in the database:

    1. In the Object Explorer pane expand Databases > < Newdatabase > > Security.

      Where <New database> is the database that you created in Step 3..

    2. Right-click Schemas, then click New Schema….

    3. Type the Schema name.

    4. Click OK.

  6. Set the user in the database:

    1. In the Object Explorer pane, expand Databases > <Newdatabase> > Security.

      Where <New database> is the database that you created in Step 3..

    2. Right-click Users, then click New User…

    3. Type the User name.

    4. Set the Login name to the user you created in Step 4.

    5. Set the Default schema to the schema you created in Step 5.

    6. In the Database role membership area, enable:

      • db_datareader

      • db_datawriter

      • db_ddladmin

      • db_owner

    7. Click OK.

  7. Close the connection to the schema by collapsing the database tree and highlighting the root of the SQL Server management interface.

    5536.png

    This ensures that the database can be locked to perform the following operation.

  8. Alter the database collation:

    1. In the toolbar, click New Query.

    2. In the new query window, type the following:

      ALTER DATABASE <database name> SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE <database name> COLLATE Latin1_General_BIN 
ALTER DATABASE <database name> SET ALLOW_SNAPSHOT_ISOLATION ON 
ALTER DATABASE <database name> SET READ_COMMITTED_SNAPSHOT ON 
ALTER DATABASE <database name> SET MULTI_USER

      If the database name is ”default”, enclose it in square brackets: [default].

    3. Click Execute.

  9. Exit SQL Server Management Studio.

    Note the database name, and the name and password of the login that you create. You will need these values, as well as the information you gathered earlier, when you install Bravura Security Fabric .

In this section: