Using Windows Authentication for on-premise

Enabling Windows Authentication on SQL Server

If you require Windows Authentication mode to be used when accessing the Pronestor database, you have to associate a Windows AD account with the Pronestor database.

Requirement: A Windows AD account (we’ll refer to it as ‘PronestorAD’)

1. Set the Login name – my_domain\pronestorAD 
2. Choose Windows Authentication

Manually populate database structure and data

1. Navigate to the file CreateSchema.sql in c:\inetpub\wwwroot\pronestor \Models\Database
2. Double click the file, and your SQL Management Studio will automatically open the file 
3. Connect to the database - Choose pronestorDB in the upper left dropdown 
4. Click Execute

The script creates all the required tables and stored procedures. Now the database must be seeded with data (includes both necessary system data and some sample data). Pronestor supports a number of different languages for this data. Execute one of the scripts with the prefix CreateSeed in a specific language culture of your choice. E.g. if this data should be in Danish, execute the file CreateSeed_da-DK.sql.

Enabling Single Sign-On (Windows Authentication – IIS 7+)

Enabling Single-Sign-On can be enabled by setting required Windows authentication on the Internet Information Server for the Pronestor folder.

NOTE
It is required that the Internet Information Server is in the same domain as the one that the users login with on the workstations.

1. Choose Authentication in Features View
2. Disable “Anonymous Authentication”
3. Enable “Windows Authentication” 
4. Enable “Forms Authentication” 
5. Edit the file “appSettings.config” in Notepad (located in c:\inetpub\wwwroot\pronestor\Configuration) 
6. Locate the section “<appSettings>” 
7. Enable the “UseWindowsAuthentication”  - <add key="UseWindowsAuthentication" value="true"/> 
8. Save the file