Step 4: Configure a Pirouette Instance
A Pirouette instance tells the software how to access your SQL Server database. The instance is defined in the file C:\Program Files\Roxy Software\Pirouette\Pirouette.conf.
Edit the Pirouette.conf file with a text editor (for example, notepad). Set the configuration files as appropriate – they are defined below.
Instance: Leave this as ‘default’.
ApplicationDirectory: The web (not file system) location of Pirouette. In this case, as we’ve installed the application as the default website, leave this blank.
DataSource: The SQL Server name
Provider: Leave this as ‘sqloledb’ as you’re using a SQL Server database.
Catalog: The name of your Pirouette database.
UserID: The user ID Pirouette should use when accessing the database. Note that you must enable SQL Server authentication.
Password: The related password.
ReadOnlyUserID: Custom queries and reports are executed using a read-only SQL Server account. Specify an account with read-only permissions here.
ReadOnlyPassword: The related password.
CachedHeaders: In general, you’ll want to leave this on as the application will runmuch faster.
Debug: You don’t need to use this unless you’re developing new panels, and run into trouble.
BackupLocation: Prior to applying an update a backup will be automatically in this location.
PirouetteLocation: The filesystem location of the installation directory.
WebRootLocation: The actual filesystem location of the WebRoot directory.
Modules: A comma-separated list of the modules to register. Unless you are developing your own custom modules, this will typically read ‘Framework,Case Management’ to indicate that you are registering the core Pirouette framework and case management modules.