How to create a database using Pervasive Control Center
Description

For Sage Intelligence and enhanced search to work you need to have a database connection for the company on Pervasive Control Center. The database connection is usually automatically created when you run Sage Intelligence reports for the first time or you use enhanced search for the first time.

If for any reason the database connection is not created you can create the database connection manually on Pervasive Control Center.

Cause
Resolution

Creating Database using Pervasive Control Center           

  1. Open the Run command by pressing the Windows logo key Picture of the Windows logo key+R on your keyboard
  2. Type pcc as shown below and click OK
  3. In the Pervasive Control Center there are two panes, on the left-hand pane expand Engines you should see the server computer name. Expand the computer name to see Databases as shown below:


      NOTE: If using Pervasive Workgroup it will be the workstation name and on a Client/Server Installation it will be the Server name. 

    If on a Client/Server installation you need to Expand on the server’s computer name. If the server’s computer name is not showing, right click on Engines, select New  and select Server. Enter the server’s computer name and click OK.

  4. Right click on Databases, select New and then Database
    Graphical user interface, applicationDescription automatically generated
  5. On the New database screen enter the company name on the Database Name field. The database name should start with PAS19 and then the company folder name e.g. if your company folder is DEMO, you should enter the database name as PAS19DEMO
  6. On the Location field click on the eclipse button as shown below and navigate to the company folder. Select the company folder and click OK.
  7. Once you have selected the company folder make sure that the above is as per the screenshot and you have deselected the option Create Engine DNS
    .
  8. Click Finish and close the Pervasive Control Centre
Steps to duplicate
Related Solutions