ThingWorx Flow > Installation and Configuration > Installing ThingWorx Flow > ThingWorx Flow Prerequisites for Microsoft SQL Server
ThingWorx Flow Prerequisites for Microsoft SQL Server
The following sections provide information about the prerequisites that you need to set before you install ThingWorx Flow:
Prerequisites for Windows Server 2016, Windows Server 2019 with Microsoft SQL Server
You must have the following:
Windows Server 2016/ 2019 with Administrator access
<JAVA_HOME>/bin added to the PATH environment variable.
A local or remote database connection for ThingWorx Flow. The following table provides the prerequisites that you need to set:
Database Connection
Prerequisites
Local database connection
The host on which ThingWorx Flow is to be installed must have access to Microsoft SQL Server.
A valid Microsoft SQL client (sqlcmd) is installed and is available in the PATH environment variable.
A Microsoft SQL user with Administrator access.
Remote database connection
Install sqlcmd and make it available in the PATH environment variable.
Use the existing ThingWorx Foundation database or create a separate database for ThingWorx Flow. Ensure that you have not used this database for a previous ThingWorx Flow installation. For ThingWorx Flow, you must set the following configuration settings on the database:
Set Collation to your collate. For example: Latin1_General_100_CS_AS_SC. See Microsoft documentation to View Collation Information.
Set Auto Close to False.
Set Allow Snapshot Isolation to True.
Set Set Read Committed Snapshot On to True.
Ensure that your database user has the following settings and privileges:
Create a login for the Microsoft SQL Server with an SQL Server Authentication.
While creating the login, set Default database to master, select the Enforce password policy check box, and do not select the Enforce password expiration check box.
Create a database user for that login. The username and password for this login provide the ThingWorx Flow Database Login Username and the ThingWorx Flow Database Login Password.
Set the database user as the owner of the database by adding it as a member of db_owner role of that database.
From your Microsoft SQL Server database, note the following values:
SQL Server IP Address or Host Name
SQL Server Port
SQL Server Instance
ThingWorx Flow
ThingWorx Flow Database Login Username
ThingWorx Flow Database Login Password
* 
ThingWorx Flow does not support Force Encryption mode for Microsoft SQL Server. Ensure the value for Force Encryption mode is set to No before installation.
Prerequisites for Red Hat Enterprise Linux 7.5, 7.6, 8.0, 8.1, or 8.2 with Microsoft SQL Server
* 
Ensure that you are installing ThingWorx Flow on the supported version of Red Hat Enterprise Linux. For more information, see Supported operating systems.
Red Hat Enterprise Linux 7.5, 7.6, 8.0, 8.1, or 8.2 with Administrator access.
For Red Hat Enterprise Linux 8.0, 8.1, or 8.2, ensure that you register and subscribe a system to the Red Hat Customer Portal using Red Hat Subscription Manager.
In the /etc/selinux/config file, set SELINUX=enforcing, and restart the machine.
Run the following commands to enable Software Collections:
For Red Hat Enterprise Linux 7.5, 7.6
yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 RHSCL (RPMs)'
yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 Extra(RPMs)'
yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 Optional (RPMs)'
yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 RH Common (RPMs)'
yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 Supplementary (RPMs)'
For Red Hat Enterprise Linux 8.0, 8.1, 8.2
yum install scl-utils scl-utils-build
Run the following commands to enable EPEL repository:
For Red Hat Enterprise Linux 7.5, 7.6
1. wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
2. yum localinstall epel-release-latest-7.noarch.rpm
For Red Hat Enterprise Linux 8.0, 8.1, 8.2
1. wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm
2. yum localinstall epel-release-latest-8.noarch.rpm
<JAVA_HOME>/bin added to the PATH environment variable.
A local or remote database connection for ThingWorx Flow. The following table provides the prerequisites that you need to set:
Database Connection
Prerequisites
Local database connection
The host on which ThingWorx Flow is to be installed must have access to Microsoft SQL Server.
A valid Microsoft SQL client (sqlcmd) is installed and is available in the PATH environment variable.
A Microsoft SQL user with Administrator access.
Remote database connection
1. Install sqlcmd and make it available in the PATH environment variable. For instructions on installing sqlcmd, see Install sqlcmd on Linux.
2. After installation, run the following command:
ln -s /opt/mssql-tools/bin/sqlcmd /usr/bin/sqlcmd
Use the existing ThingWorx Foundation database or create a separate database for ThingWorx Flow. Ensure that you have not used this database for a previous ThingWorx Flow installation. For ThingWorx Flow, you must set the following configuration settings on the database:
Set Collation to your collate. For example: Latin1_General_100_CS_AS_SC. See Microsoft documentation to View Collation Information.
Set Auto Close to False.
Set Allow Snapshot Isolation to True.
Set Set Read Committed Snapshot On to True.
Ensure that your database user has the following settings and privileges:
Create a login for the Microsoft SQL Server with an SQL Server Authentication.
While creating the login, set Default database to master, select the Enforce password policy check box, and do not select the Enforce password expiration check box.
Create a database user for that login. The username and password for this login provide the ThingWorx Flow Database Login Username and the ThingWorx Flow Database Login Password.
Set the database user as the owner of the database by adding it as a member of db_owner role of that database.
From your Microsoft SQL Server database, note the following values:
SQL Server IP Address or Host Name
SQL Server Port
SQL Server Instance
ThingWorx Flow Database Name
ThingWorx Flow Database Login Username
ThingWorx Flow Database Login Password
* 
ThingWorx Flow does not support Force Encryption mode for Microsoft SQL Server. Ensure the value for Force Encryption mode is set to No before installation.
Was this helpful?