1. Create the shared repository database on your database server
As you are installing a new instance of Perception, you now need to create a database for your shared repository.
The shared repository database needs to be created on your database server.
The full version of SQL Server 2008 R2 must be used for the shared repository, Perception_MAIN, and Perception_RW databases.
Select the database system that you are using on your database server and follow the instructions:
Before you create the shared repository database
In SQL Server, there are two database collations you need to set: the SQL Server collation and the Database collation.
For English and non-English characters to appear correctly when using SQL Server, your collations should be set as:
Users wishing to set up an English language version of Perception on a non-English operating system and database should ensure that the correct language packs are installed for both the database and the operating system. Additionally, the language pack 1252 (ANSI - Latin 1) must be installed for both servers and the SQL Server collation and database collation set to SQL_Latin1_General_Cp1_CI_AS.
The question searching facility in Authoring Manager requires the full-text indexing component of SQL Server to be installed and configured and will not work without it. Once full-text indexing is installed, it will need to be enabled for the database before the repository is created.
Create a database and user for the shared repository
To create a SQL Server 2008 R2 database for use with Perception:
- Open SQL Server Management Studio
- Right-click the Database folder on the attached database server and select New database
- Enter the database name. For example, Perception_REPO.
- From the Options page set the collation to SQL_Latin1_General_CP1_CI_AS and click OK
Once you have created your database, you need to set up a new login. To do so:
- Still in SQL Server Management Studio
- Expand the server folder for the server on which you have created your database in the navigation pane
- Expand the Security sub-folder
- Right-click Logins and select New login...
- Enter a name for the new login. For example, Perception_REPO.
- Select SQL Server Authentication and enter a password
- Uncheck the Enforce password expiration and User must change password at next login checkboxes
- In the Default database list, select the database you created above. For example, Perception_REPO.
- Open the User Mapping page and tick the database you created
- Enable the db_owner and public permission checkboxes
- Navigate to the Server Roles page
- Enable the bulkadmin and public server role checkboxes
- Click OK
Switch on full-text indexing for the shared repository database
If you intend to use question searching in Authoring Manager, you will need to ensure that full-text indexing is enabled for the shared repository database. To enable full-text indexing in SQL Server Management Studio:
- Right-click on the shared repository database (Perception_REPO), and select Properties
- Click Files from the Select a page menu
- Enable the Use Full-text indexing checkbox
- Click OK
If the checkbox is already ticked and grayed out, this is because full-text indexing has been enabled for the whole server, meaning all the databases have full-text indexing enabled by default.
Now that you have created a user and database for the shared repository, you will need to create an ODBC connection to it on your Perception server. For information about how to do this, please continue to step 2 using the link below.