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	ü	ü

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 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.

Message Broker server

The following software is required on the Message Broker server:

• RabbitMQ 3.8.5

• Erlang OTP 23.0.1 (11.0.1)

See Install the Message Broker server for more information.

Web server

The following software is required on the Web server:

• .NET Framework 4.7.2

• IIS 10.0

• .NET Core Windows Server Hosting 3.1.3

• .NET Core Windows Desktop Runtime 3.1.3

• Visual C++ Redistributable 2012 (x64)

See Install and configure the web server – Hub for more information.

Minimum SQL permissions

The minimum SQL permissions for a 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)

A 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

When using Windows Authentication, the account set as the Identity of the Application Pools requires access to the Blue Prism database for Hub Control Room and Interact purposes. The account must have the minimum SQL permissions to access the Blue Prism database. The required permissions are:

• db_datareader

• db_datawriter

When using SQL Authentication, the same requirements apply as for Windows Authentication, but for the SQL account specified in the installation parameters.

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.

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