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.

prsql1.png

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

prsql2.png
prsql3.png

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.

prsql4.png

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

prsql5.png

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.

prsql8.png

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

prsql9.png

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

prsql10.png
prsql11.png

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.

prsql13.png

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

prsql14.png

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

prsql15.png

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

prsql16.png

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

prsql18.png

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

prsql19.png

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

prsql20.png

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

prsql22.png

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

prsql23.png
prsql25.png

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

prsql26.png