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’)
- Set the Login name – my_domain\pronestorAD
- Choose Windows Authentication
Manually populate database structure and data
- Navigate to the file CreateSchema.sql in c:\inetpub\wwwroot\pronestor \Models\Database
- Double click the file, and your SQL Management Studio will automatically open the file
- Connect to the database - Choose pronestorDB in the upper left dropdown
- 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.
It is required that the Internet Information Server is in the same domain as the one that the users login with on the workstations.
- Choose Authentication in Features View
- Disable “Anonymous Authentication”
- Enable “Windows Authentication”
- Enable “Forms Authentication”
- Edit the file “appSettings.config” in Notepad (located in c:\inetpub\wwwroot\pronestor\Configuration)
- Locate the section “<appSettings>”
- Enable the “UseWindowsAuthentication” - <add key="UseWindowsAuthentication" value="true"/>
- Save the file