Setting Security Rights in SQL Server 2012 or later Using Windows Authentication with Noah 4.x

The purpose of this document is to complete the setup for Noah 4.x to use SQL 2012 or later with Windows Authentication. If you are using Mixed Mode Authentication, you do not need to perform the steps below. There are some security enhancements in SQL 2012 that were not present in previous versions of SQL.

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

The examples in this document are using Windows Server 2008(64-Bit) Standard as the operating system. The SQL Server is SQL Server 2012 (64-Bit) Enterprise. SQL Server was installed on the same machine as Noah 4.

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.