Hub software requirements and permissions

Software requirements

The following technologies are supported for use with the software:

Operating system

Version

Web Server

Message Broker

Windows Server 2016 Datacenter

ü

ü

Windows Server 2019

ü

ü

Where the Blue Prism components are installed on a 64-bit operating system, it will run as a 32-bit application.

Microsoft SQL server

The following Microsoft SQL Server versions are supported for locating the Blue Prism component databases:

Version

Express

Standard

Enterprise

SQL Server 2016

ü

ü

ü

SQL Server 2017

ü

ü

ü

SQL Server 2019 (64-bit)

ü

ü

ü

SQL Express is only appropriate for non-production environments, such as for the purposes of proof of concept exercises.

The following are also supported:

  • SQL Server on Azure Virtual Machines.
  • Azure SQL Managed Instance, however, the databases must be created before the installation.

Azure SQL Database is not currently supported.

Minimum SQL permissions

The minimum SQL permissions for the user required to connect to the database during the installation process must have the appropriate privileges to create or configure the databases from within the product, therefore an appropriate administrator account will need to be used when running the installation process:

  • Create Database: dbcreator (server role) or sysadmin (server role)
  • Configure Database: sysadmin (server role) or db_owner (database role)

The database user required to connect to the databases during normal operation must have the minimum SQL permissions to access the Hub and IMS databases. The required permissions are:

  • db_datareader
  • db_datawriter

For more information, see Default application information below.

Default application information

The information below shows the applications that are created by the installation using the default values. All applications should have full access to the BluePrismCloud_Data_Protection certificate located in the certificate store on the local machine. IIS APPPOOL\ Blue Prism – IMS will also require access to the BluePrismCloud_IMS_JWT certificate. IIS APPPOOL\ Blue Prism – IMS and IIS APPPOOL\ Blue Prism – SignalR will also require access to the BluePrismCloud_IMS_JWT certificate.

Hub websites

Application name

Example service account name for SQL Windows Authentication

SQL Server permissions required during installation

Database permissions required during application running

Default database name

Blue Prism ‑ IMS

IIS APPPOOL\ Blue Prism – IMS

dbcreator / sysadmin

db_datawriter / db_datareader

ImsDB

Blue Prism ‑ Hub

IIS APPPOOL\ Blue Prism – Hub

dbcreator / sysadmin

For the first login and initial configuration:

dbcreator / sysadmin

Subsequent logins:

db_datawriter / db_datareader

HubDB

Blue Prism ‑ Email

IIS APPPOOL\ Blue Prism – Email

N/A

N/A

N/A

Blue Prism ‑ Audit Service

IIS APPPOOL\ Blue Prism – Audit Service

dbcreator / sysadmin

db_datawriter / db_datareader

AuditDB

Blue Prism ‑ File Service

IIS APPPOOL\ Blue Prism – File Service

dbcreator / sysadmin

db_datawriter / db_datareader

CacheDB

Hub services

Application name

Example service account name for SQL Windows Authentication

SQL Server permissions required during installation

Database permissions required during application running

Default database name

Blue Prism ‑ Audit Service Listener

NT AUTHORITY\SYSTEM

dbcreator / sysadmin

db_datawriter / db_datareader

AuditDB

Blue Prism ‑ Log Service

NT AUTHORITY\SYSTEM N/A N/A N/A