QPR Knowledge Base

Set Up Microsoft SQL Server for QPR Products

Hide Navigation Pane

Set Up Microsoft SQL Server for QPR Products

Previous topic Next topic No expanding text in this topic  

Set Up Microsoft SQL Server for QPR Products

Previous topic Next topic JavaScript is required for expanding text Mail us feedback on this topic!  

Comments (...)

Here are the instructions for setting up a Microsoft SQL Server DBMS for QPR products:

Install Microsoft SQL Server.


For Microsoft SQL Server installation instructions, see the MS SQL Server manual.



Create and configure a database for QPR products.


All QPR products use a single database instance, so you need to create and configure only one database for the whole system.


Please consult your Microsoft SQL Server manual for instructions on creating a new database.


A minimum QPR database should work fine with the default database configurations. However, make sure that there is enough hard drive space allocated for the database tablespace as well as the transaction log. They both should have space for at least 100 MB of data. With larger amounts of data the allocations and database settings most probably need to be adjusted.


You can test your database configuration by clicking the Test Database Configuration button at the Database tab of the Common section in the QPR Configuration Manager utility, which can be found at the Utilities folder under your QPR 8.1 installation folder.


Verify also that there is an ODBC data source configured for the database and configure it if needed. In 64-bit Windows environments, the data sources configured with the ODBC Data Source Administrator available in the Control Panel cannot be seen in QPR Configuration Manager. To be visible, the data source must be configured with "odbcad32.exe", which can be found in C:\WINDOWS\SysWOW64.



Continuing with the Installation


Database installation is complete. However, before taking the database into use, you need to create the product-specific contents to it by using the QPR Configuration Manager utility. The database contents are created with the Create new database option in the Database Operations tab of the Common section. Note that you need to install the software before you can access the configuration utility, so you will have to create the QPR contents later during the installation procedure.

Comments (...)