Setting Security Rights in SQL Server 2014 or later when using Windows Authentication with Noah 4.x

The purpose of this document is to complete the setup for Noah 4.x to use SQL 2014 or later with Windows Authentication. If you are using Mixed Mode Authentication, you do not need to perform the steps below.

The directions below are to be completed after the switch is made from Noah 4.x using the default database to Noah 4.x using a Microsoft SQL 2014 or later with Windows Authentication. Please complete the steps listed on this page first.

1. Launch the SQL Studio Management Studio utility.

2. Once the SQL Studio Management Studio utility is opened, navigate to the security\logins under the Server\Instance icon in the tree structure. Select the NT Authority\System Login. Please see the picture below.

3. Right click on the NT Authority\System Login and select Properties. Please see the picture below.

4. Once the properties for the NT Authority\System login appear, select the “User Mapping” option in the list.

5. Once you have selected the User Mapping option find the listing for NOAHDatabaseCore listing under the “Users mapped to this login.” You must check the box for the NOAHDatabaseCore. Please see the picture below.

6. Once the NOAHDatabaseCore is checked look down at the list under “Database role membership for: NOAHDatabaseCore” you will see only public is checked. Check the db_owner option in the list, so both db_ower and public will be checked. Then select OK to save the change. Please see the picture below.

7. The final step is to restart the server.