Hi Ilona Jacobs 

Please follow the steps below to add the company database manually to your Sage Intelligence

 Deleting the existing database:

 Go to View...Intelligence Reporting...Launch...Report Manager

Right click on Home under the File menu and a screen as shown below will appear

Select PVS.SQL DB Manager from the list

Enter the server name (please note that on Pervasive Workgroup it will be the computer name of the workstation and on a Client/Server Installation it will be the computer name of the Server)

Double click on the Computer name.

Locate the database for the company you want to run your report for

Right Click on this and left click on delete.

Creating a Database using Report Manager:

Right click on the server name and select Add Database Name as shown below

Enter the database name 

The database name should start with PAS19 and then the company folder name e.g. if your company folder is DEMO16, you should enter the database name as PAS19DEMO16 or PAS18DEMO16 depending on the Pastel version you are running.

Select the company folder when prompted to select the DDF File Path as shown below and click OK

Select the company folder when prompted to select the DDF File Path as shown below and click OK

The company will start showing on the databases as shown below. Click on Verify DDF File Path and Verify DAT File Path and ensure that you get the message OK

 Once that is done, please run your reports again.

if my answer does help: please let me know by clicking on verify answer

Hi there Ilona Jacobs 

How did it go with the fix suggested?

If it did help you please click on verify answer.

Shazi