Setting up the Pronestor database - SQL

This manual is ONLY to be used if you are using Pronestor Visitor without Pronestor Planner.

When creating a database, you need to perform the following tasks:

• Create an empty database
• Create the database structure
• Populate with seed data

Create database on Microsoft SQL

Setting up a database on the SQL server requires that you have installed or has access to a SQL 2008 server. To work on the SQL Server you need to launch the SQL Server Management Studio.

• Launch SQL Server 2008 Management Studio – you’ll find this tool in Start->All Programs->Microsoft SQL Server 2008
• Connect to the database by logging in to the SQL Server
• Choose Databases folder in the left menu, right-click and select New Database
• Give the database a name (we’ll refer to it as ‘PronestorDB’) 
  
  
  
  
  
  
• Click OK to create the database, and close the “New database” window
• Expand Security in the left menu – and the right-click Logins and choose New Login 
  
  

Using SQL Server authentication?

• Set the Login name (we’ll use ‘PronestorUser’ in these guide)
• Choose SQL Server Authentication
• Set a password and confirm password 

Important
Please pay attention to the requirements regarding “Password policy”, “Password expiration”, and “Change password”. If you are running a simple setup and don’t have strict policies on passwords, please disable these.

• Choose User Mapping in the left menu
• Enable ‘PronestorDB’ in the upper window
• Set the following database role memberships for the database

1. db_datareader
2. db_datawriter
3. db_owner

Using Windows authentication?

If you require that Windows Authentication mode is 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 ‘my_domain\PronestorAD’)

• Set the Login name – my_domain\PronestorAD
• Choose Windows Authentication
• Choose User Mapping in the left menu
• Enable ‘PronestorDB’ in the upper window
• Set the following database role memberships for the database

1. db_datareader
2. db_datawriter
3. db_owner

Setting up structure and populate database with data

IMPORTANT - this section is ONLY relevant if the Pronestor Web App can't create the schema automatically. 

Okay, now we have created a database (PronestorDB) and added a user with access to the database. Next step is to set up the structure and populate the database with Pronestor data.

For this step, please download the attached database and make a restore from it.It contains the structure and some demo data to get you started.