Winsby Group LLC Corporate Logo

PIESCentral Hardware and Software Requirements

MS SQL SERVER (2014 or later)

  1. Read/Write access to a local directory on the database server (with sufficient disk space)

  2. Ability to restore an “empty” PIESCentral database to the SQL Server.

  3. TCP/IP access to connect to the SQL Server from Client PC location.

  4. Need SQL Server Machine Name (and Instance Name if applicable)

  5. Need the Client Login account or group granted access to the database (Windows Authentication is recommended)

  6. A user needs db_ddladmin (or db_owner) access to the database for database updates to be automatically applied (otherwise IT staff would need to manually apply them).

CLIENT PC (Minimum 2GHz CPU, 4GB RAM with Win10 or later)

  1. Need Administrator privileges

  2. Need .NET Framework 4.8 installed - PIESCentral Setup will install this if not found.

  3. Need Microsoft SQL Server (either Express or the full Server Edition) SQL Server Downloads

  4. Need Client Access to the SQL Server using either SQL Server Native Client or OLE DB Driver for SQL Server (the latter of which is installed by PIESCentral Setup)

  5. Need to install Microsoft Core XML Services MSXML 6.0

  6. Need to install Microsoft SQL Server Management Objects x86 even if x64 is already installed from the feature pack that matches your SQL Server version. For example, if you are using SQL Server 2019, you would install the Microsoft SQL Server 2019 Feature Pack.

  7. Need TCP/IP access to the SQL Server if the SQL Server is on a different machine than the Client PC. This is usually enabled by default, but can be checked in the SQL Server Configuration Manager.

  8. Need to install PIESCentral application

If you are unable to connect to the database, see this article for troubleshooting tips.

OPTIONAL SCHEDULER

PIESCentral allows unattended data refreshing and publishing on a scheduled basis. A “console” application is provided for this purpose and is launched using the Windows Scheduler. This is an optional feature and not required to operate the software.

If you want to enable scheduled import scripts, a separate program for this purpose (piescentral-runner) must be installed on the SQL Server or other available Windows Server with network access to all defined data sources.

The same scheduler can also be used to automate the publication of pre-configured “documents”.

See the Scheduler Section for more information.

Revised: 2010-04-10
Next