Follow

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.

Structure

  • Contact Pronestor Helpdesk and request the script: CreateSchema.sql 
  • Once you have received the script, launch your SQL Management Studio
  • Connect to the database
  • Choose PronestorDB in the upper left dropdown
  • Execute CreateSchema.sql on the PronestorDB

  

Populating

  • Contact Pronestor Helpdesk and request a data seed script
  • Once you have received the script, launch your SQL Management Studio
  • Connect to the database
  • Choose PronestorDB in the upper left dropdown
  • Execute the script on the PronestorDB

Data seeds are avaialable in the following languages.

 

  • Danish
  • English/Australian
  • British English
  • US English

 

You are now all done on the database server.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk