Setting up the Pronestor database - SQL

This manual is ONLY to be used if you are using Pronestor Visitor without Pronestor Room or Catering.

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 contact helpdesk@pronestor.com to recieve a database file in the correct version for your setup. This database is to be restored on your system to ensure the correct structure and population of data in the database.