PDXpert Application Server setup

The PDXpert Application Server and the SQL database server must be installed on the same computer.

You must have administrator rights to your computer, and be the only user logged into Windows. (Confirm using the Windows command query user)

1. Installation options §

Choose one of the following options (A. or B.) to install the PDXpert system.

A. Standard installation with integrated SQL Server§

The standard installation automatically downloads and installs SQL Server Express LocalDB. This is a secure, low-profile, minimal footprint version of SQL Server. It's intended to support workgroups of up to about 10 users. The installation is fast, and won't affect other database applications.

Procedure A

  • Run the PDXpert system installation program from your server's local storage.

B. Optional installation for separate SQL Server§

Use this option if you prefer PDXpert to use your selected SQL Server instance, and don't want PDXpert to install its own SQL Server instance.

SQL Server requirements

  • The Local System account (NT AUTHORITY\SYSTEM) must be the service user; and

  • The user who installs PDXpert must be one of the SQL Server instance's system administrators.

For the recommended procedure to manually install SQL Server for PDXpert, see Custom installation: SQL Server.

Procedure B §

  1. Run the PDXpert installer on the computer where SQL Server is installed:

    • For PDXpert 10.0 and later: From the Windows Start menu, open a command line prompt using Run as administrator, and execute the system setup using the db=0 option:

      C:\>{path}\PDXpertSystemSetup-{release}.exe db=0

      For example:

      Installer command line option
    • For releases earlier than PDXpert 10.0: Run the setup EXE file by double-clicking the Windows icon.
  2. After installation and before running the PDXpert client, open the PDXpert Application Server and click the Change Database Server… button to select your installed SQL Server instance. Select (or enter) the local instance name that PDXpert will use, like .\PDXPERT.

    You'll see two messages: Changing database server and then Status: Starting services. These processes may take up to 3 minutes. If it takes longer, SQL Server may not be accepting your permissions. Shut down and restart the PDXpert Server application, and this may finish the task.

2. Continuing the setup§

To complete the PDXpert Application Server setup:

  1. During installation, the PDXpert software license agreement is shown. If you agree with the terms of the license, mark the acceptance checkbox, and click the Next button.

  2. Although you can specify options for the PDXpert Application Server, we recommend using the default values to simplify administration and technical support.

    The installer creates a folder for your database and library on your system drive. If you prefer to use another location for your data, allow the installation to proceed. After installation is complete, use the Settings tab on the PDXpert Application Server console to select your preferred location for the data folder.

  3. When the installation is complete, click the Finish button. On the Windows Desktop, there are two icons:

    • The PDXpert client application is used for administrative tasks (license entry, user account management, etc.) and normal product data management activities.
    • The PDXpert Application Server is used for database management tasks such as backup, restore, relocation and reset.