/
Adding a new user in SQL server for BrDR

Adding a new user in SQL server for BrDR

Date

August, 2022

Product

AASHTOWare BrDR

Version

7.2, 7.1, 7.0

Description

How do I add a new user in SQL server for BrDR?

How do I add a new user in SQL Server for BrDR?

 

To add a new user to BrDR, two steps need to be taken:

  1. Add a new user in SQL Server

  2. Create a new user in BrD, BrR, or BrDR

 

The following sections outline these two steps.

Add a new user in SQL Server

Before adding the user to BrDR, add the user to SQL Server, use the following steps:

1. Start ‘SQL Server Management Studio’ by right clicking and using the ‘Run as administrator’ option (see below).

2. Once logged in, got to ‘Security->Logins’, right click, and select ‘New Login’ (see below).

3. In the window shown below, select SQL server authentication. If you do not want to enforce a password reset and policy standard, uncheck the enforce password policy check box (see below).

4. Simply enter the login name and password for this new user. NOTE: the login name must match the BrDR user that will be created in the next step.

 

5. Before selecting OK, map the user to the database. In the case shown, it was ‘AASHTOWareBr72s so the new user is mapped to this database. Please also give the user the VIRTIS_USER_READ_ONLY_ROLE as well so they can log into the database (see below).

Create a new user in BrD, BrR, or BrDR

Now that the user login has been created in SQL, a new user can be added in the BrDR application, use the following steps:

1. Add the user to BrDR system by starting the BrD, BrR, or BrDR application.

2. Log into BrDR using a username that has read, write, and create turned on for the access rights privilege.

3. Open the Configuration Browser (see below).

 

4. Select the user group (such as ‘All Users’) for which the user will be a member (see below).

5. Select New User from the Configuration ribbon tab (see below). Enter the user information; note that the ‘User ID’ must match the ‘Login Name’ created in SQL. For the ‘Member of’ section, select each of the classifications that the user will be a ‘Member of’ (see below). Click the Save button.

6. After adding, the user can now log into BrDR with the ‘NewUser’ credentials.