    |
|
The QA Wizard Pro Server stores playback data in a Relational Database Management System (RDBMS). SQLite is the default RDBMS and does not require any setup or configuration before or after installation. The server database is created automatically when the server starts, but you can change the database location.
You can also use a Microsoft SQL Server, Oracle, or PostgreSQL database for the server database, but you must create an empty database before configuring it in QA Wizard Pro. See Setting Up RDBMS Databases.
Note: If you change the server database, data in the current server database is not copied to the new database. You should not need to change the database location frequently.
1. Start the QA Wizard Pro Server Admin Utility.
2. Click Server Options.
The Server Options dialog box opens.
3. Click the Database tab.
4. Select the database Type.
5. Enter the database Options. The available options depend on the selected database type.
| Database type | Options |
|---|---|
| SQLite | By default, the Database file path is set to the QAWServer.db database file that is automatically created in the C:\QAWServer directory. If you moved the database file to a different directory, click Browse to select the database location. You can also select a different directory to automatically create a new database file in when the server restarts. |
| Microsoft SQL Server | Enter the Server address, Server port, and Database name for the database you created. Select an authentication method to use to connect to the database. Use Windows Authentication uses the username and password of the logged in user on the server computer. Use SQL Server Authentication uses the provided SQL Server User and Password. The database configuration may affect playback data removals. See Incorrect Playback Sessions May Be Removed from QA Wizard Pro SQL Server Databases. |
| Oracle | Enter the Server address, Server port, and Service name for the database you created and the Oracle User and Password to connect to it. |
| PostgreSQL | Enter the Server address, Server port, and Database name for the database you created. Select an authentication method to use to connect to the database. Use Windows Authentication uses the username and password of the logged in user on the server computer. Use PostgreSQL Server Authentication uses the provided PostgreSQL User and Password. |
6. Click Save to save the changes.
You must restart the QA Wizard Pro Server for the changes to take effect. See Starting the QA Wizard Pro Server.
| |
|