Database setup for Questionmark Perception

Applies to the following products: 
Questionmark Perception
Applies to the following Perception versions: 
Perception 5.2
Perception 5.1

This chapter describes how to create and configure the following types of database to use as your Questionmark Perception Version 5 repository:

You should only use SQL Server 2005/2008 Express for light use or evaluation and demonstration purposes. For production purposes where you expect to deliver more than 1000 assessments per week we strongly recommend that:

  • You use a SQL Server or Oracle database

  • Your database is located on a separate application server to your Perception Server

To create a new database for use with Perception, follow the instructions in the sections above.

The default instructions for setting up an SQL Server use SQL authentication. However, if you would prefer to use Windows authentication with your Perception database this is possible provided you are using SQL Server 2005/2008. To find out how to use Windows authentication please refer to the following section in theAdvanced configuration options chapter:

Database Windows authentication