Skip to main content

Overview for setting up Microsoft SQL Server

The following is an overview of required and optional tasks for setting up Microsoft SQL Server to work with Bravura Security Fabric . The tasks are detailed in the sections that follow.

Caution

Express editions should only be used for evaluation purposes. Bravura Security strongly recommends that, whenever possible, you use an enterprise or standard edition rather than the express database edition. Bravura Security does not provide support for product issues resulting from clients upgrading their database edition.

Read Supported database management systems and Where to install the software to determine appropriate version for your organization.

To set up Microsoft SQL Server :

  1. Install the SQL Server software if you haven’t already.

  2. Gather information about your database server that will be required during Security Fabric installation .

  3. Optional: Create a dedicated database, user, and schema .

    Alternatively, you can allow Bravura Security Fabric setup to do this for you, as described in Configure a dedicated database user .

  4. Optional: Create a dedicated report database user .

    You can allow Bravura Security Fabric setup to do this for you, as described in SSRS settings .

  5. Optional: Remove public/guest permissions .

  6. If you will be using multiple Bravura Security Fabric instances or servers (replication), read Working with multiple installations for additional considerations.

    Follow Microsoft’s best practice guide when setting up your SQL server.

In this section: