Windows Server 2016, 2019 and 2022 Installation Guide
This guide details the software requirements and installation instructions for running ResourceXpress on Windows Server 2016, 2019, or 2022.
Please ensure the hardware requirements detailed in the section On-Prem Installation (RX v5*) have been met.
Please contact helpdesk@qedas.com to request the ResourceXpress installation kit required for this setup.
Carry out the below steps in the order listed to complete an initial, first-time installation of ResourceXpress V5.
Create the Application Database
We recommend hosting the ResourceXpress database on an existing remote SQL server.
For installations of 10 room profiles or below you can optionally use a local SQL Server Express installation to host the ResourceXpress database.
Step 1: Open SQL Server Management Studio (SSMS) and login to the local or remote SQL server that will host the application database.
Step 2: In the left pane right-click Databases and select New Database…
Step 3: In the General section, enter rxpress as the database name.
Step 4: Click Options in the left pane. Select Simple for the Recovery model. Default SQL Server instance collation should be used for the database collation. This can be either Latin1_General_CI_AS or SQL_Latin1_General_CP1_CI_AS based on the default collation set in your SQL Server.
Â
Step 5: Right-click the new database and select New Query. Copy the entire contents of the file 01 Qed OnPrem DB.sql into the query window and execute the script. Alternatively, you can select File - Open - File in SSMS - select the required script - Execute.
Step 6: Copy the entire contents of the file 02 Qed OnPrem DB Initial Data.sql into a new query window and edit the below values.
Line | Value | Content |
---|---|---|
8 | Tenant Name | Your company name e.g. ‘My Company’ |
9 | Tenant Email Id | Your initial ResourceXpress admin accounts email address e.g. ‘admin@domain.com’ |
10 | tinyint= | The numerical value for your backend booking system type e.g. tinyint=2 Values available Local RX Profiles only = 1 Exchange/Office 365 = 2 Google Workspace = 3 FM:Systems Resource Scheduler = 4 Accruent EMS = 5 NFS Rendezvous = 6 |
The below example would set the booking system type to Exchange/Office 365 and would create an initial admin account with the email address admin@domain.com. The default password for the initial admin account is RXv5Adm1n
------------------------------------------------------------------
-- Tenant Config - Tenant DB
------------------------------------------------------------------
-- TODO: need to update initial values
DECLARE @TenantId INT=1
DECLARE @Name NVARCHAR(250)='My Company' -- Enter the customer name
DECLARE @EmailId nvarchar(100)='admin@domain.com' -- Enter the email id for the admin login. Default password will be RXv5Adm1n
DECLARE @BookingSystemType tinyint=2 -- Enter the booking system type id
-- 2 = Exchange/Office 365
-- 3 = Google
-- 4 = Asure
-- 5 = EMS
-- 6 = NFS
When the required edits have been made, execute this script.
Step 7: Repeat the instructions in Step 5 for the remaining file, 03 Qed OnPrem DB Migration SP.sql, with no changes to the content.
You have now scripted your application database. Make a note of the below values which are required at a later stage of the installation.
SQL Server Name/Instance
Database Name
SQL ‘sa’ password or the username and password of an account with db_owner permissions over the ResourceXpress database.
Install and Configure Internet Information Services (IIS)
IIS Requirements
A website dedicated to ResourceXpress
A new Application Pool running .NET Framework 4.0 Integrated Mode
Request Filtering enabled (IIS 8.5 only)
Install IIS
ResourceXpress requires IIS which is part of the Web Server role in Windows Server. Please use the below steps to install and configure the new IIS instance.
Step 1: Open Server Manager from the search bar or taskbar.
Step 2: In the top right-hand corner of Server Manager select Manage - Add Roles and Features. Click Next on the Before You Begin page. Select Role-based or feature-based installation on the next screen and click Next. Choose the server to install to on the next page and click Next.
Step 3: On the Server Roles page expand the Web Server (IIS) Role and ensure Web Server and Management Tools options are selected. Expand both these sections and install all roles and features from the below image. then click Next.
Â
Step 4: Expand the section .NET Framework 4.8 Features and ensure all features are selected for installation. Click Next then Install on the confirmation page.
Â
Configure IIS
Step 1: Type IIS in the search bar and open Internet Information Services (IIS) Manager
Step 2: Expand the Server Name in the left pane and right-click Application Pools then choose Add Application Pool….
Specify the following values in the Add Application Pool window and click OK.
Name | ResourceXpress |
.NET CLR version | .NET CLR Version v4.0.30319 |
Managed pipeline mode | Integrated |
Start application pool immediately | Yes |
Step 3: By default, ResourceXpress will be installed under the Default Website. If you need to run the application from a new website create it by right-clicking Sites in the left pane and select Add Website….
IIS is now successfully configured.
Install ResourceXpress
Application Installation
Step 1: Navigate to the RXV5 installation kit provided by the helpdesk, right-click setup.exe and Run as administrator
Step 2: Click Next on the initial installation screen and on the next screen select the Site and Application Pool to install too. Click Next on the final screen to begin the installation. Close the installer when complete.
File Configuration
Standard Database Connection
Step 1: Locate the applications web.config file in the website directory, typically this will be C:\inetpub\wwwroot, and edit the file in a text editor.
Step 2: Locate the <connectionStrings> section at the bottom of the file. Several edits are required to the ConnectionString parameters to link the application to the SQL database created at the start of this guide, these values are:
Parameter | Description | Example |
---|---|---|
datasource= | The server and instance name of the SQL Server | SQLSERVER\INSTANCENAME |
initial catalog= | The database name | rxpress |
user id= | The username of a SQL account with db_owner permissions to the above database | sa |
password | The password for the above SQL account | password |
The below example ConnectionString demonstrates the correct syntax to use, in this example the SQL Server is named SERVER2019-RXV5 and is configured as the default instance. The database name is rxpress with a username of sa and a corresponding password of sqlpassword.
<add name="CatalogContext" connectionString="data source=SERVER2019-RXV5;initial catalog=rxpress;persist security info=True;user id=sa;password=sqlpassword;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />
Step 3: Once the correct values are specified save the web.config file and close.
Secure Database Connection (optional)
If you do not want to specify SQL credentials in clear text in the web.config file you can use the below syntax for the ConnectionString to configure a secure connection to the database instead.
<add name="CatalogContext" connectionString="data source=SERVER2019-RXV5;initial catalog=rxpress;persist security info=True;Trusted_Connection=Yes;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />
In addition to the above syntax, a domain account should now be configured in IIS that has db_owner permissions over the application database using the below steps
Open IIS Manager, expand the server node and select Application Pools
Right-click the ResourceXpress Application Pool and select Advanced Settings
Under Process Model highlight Identity and select the options button for this value
Select Custom account and click Set
Enter the relevant domain credentials, the username must be in full UPN format i.e. DOMAIN\user.name or user.name@domain.com
Click OK on all open screens and close IIS Manager
ResourceFiles Folder
Step 1: Navigate to the application installation directory, typically C:\inetpub\wwwroot and locate the ResourceFiles folder. Check the Security Permissions of the ResourceFiles folder and ensure the Users group has Read & Execute permissions.
Step 2: Copy your licence file to the ResourceFiles folder, ensure the filename is mm.lic
Step 3: Open the ResourceFiles folder and locate the Web-sample.config file. Make a copy of this file and rename the new file Web.config.
Open the Application
The application installation is complete. You can now navigate to the ResourceXpress administration console in a browser on the host server using the address http://localhost or http://<ServerFQDN or IPAddress> from a remote browser.
Install Optional Components
Push Service (Exchange/O365 only)
If you are integrating ResourceXpress to an Exchange or O365 environment it is recommended you install and run the additional Push Service component. Please refer to the guide Push Service for Exchange/Office 365 for installation and configuration instructions.
Scheduler Task
Scheduler Task is required when you have added resource profiles but do not have a physical device e.g. a room screen or desk device connected to those profiles, for example, if you are only using Kiosk and/or Maps to enable user bookings. Please see the guide Scheduler Task for further information.
Next Steps
You have successfully installed ResourceXpress V5 and can now move on to initial configuration and profile creation. Please see our and continue your setup.
Common Issues and Troubleshooting
Â
- style