Support Import

Installing SQL Server Express

Installing SQL Server Express through the ProcessRobot installer

The new ProcessRobot installer includes the capability to install Microsoft SQL Server Express directly through the installer. To install SQL Server and SQL Server Management Studio and set up the ProcessRobot database without using the ProcessRobot installer, read these articles: Installing Microsoft SQL Express 2016, Installing SQL Server Management Studio, and Setting up the ProcessRobot Database.


Having chosen to install SQL Server Express, next choose whether to enable Silent Installation.


After this choice has been submitted in the ProcessRobot installer, the SQL Server installer will launch. Once this process has been completed, the ProcessRobot installation will continue.


Accept the license terms is required to proceed with the installation.


The installer will continue through some stages, such as “Global Rules”, without requiring user input. If no issues are found the installer will continue to “Feature Selection”. At this stage, the user can select which features to install.


At the “Instance Configuration” stage, it is recommended to select “Named instance”, and select how the SQL Server Express instance will be named. If no other instance of the application exists on the machine, the default instance name is “SQLEXPRESS”.


At the “Server Configuration” stage, determine the Server Service Accounts and the database Collation type. The default collation type is Latin1_General_CI_AS.


At the “Database Engine Configuration” stage, determine settings related to Server Configuration, Data Directories, TempDB settings, User Instances and the Filestream.

Under “Server Configuration”, determine whether SQL Server Express should use only Windows authentication or both Windows and SQL Server authentication. Optionally specify a password for the system administrator (sa) account.


Under “Data Directories”, determine the directories to be used for the System, User and other SQL Server databases.


Under “TempDB”, specify the directory be used and other settings for temporary databases.


Under “User Instances”, specify if users can run multiple instances of the Database Engine.


Under “FILESTREAM”, select to enable the Filestream for Transact-SQL and file I/O access.


Following these stages, if no issues occur, the SQL Server installation will complete.


Once the SQL Server installation has completed, the user can create a SQL Server Database and User directly from the ProcessRobot installer.


To create the Database and User, the Database Host is required. Enter this in the format <machine name> \ <SQL Server instance name>, e.g. PR-SERVER\SQLEXPRESS. Then enter a username and password combination for the Database User and click “Create User”.


Next, assuming that SQL Server had not been previously installed on the machine, proceed to Create a New Database to be used for ProcessRobot.


Finally, to test that ProcessRobot can successfully connect to the newly created Database with the new User, enter the Connection String in the format:

Password=<password>; Persist Security Info=True; User ID=<username>; Initial Catalog=<database name>; Data Source=<Server machine name>\<SQL Express instance name>;

Then click “Test Connection”.