This guide details the software requirements and installation instructions for running ResourceXpress on Windows Server 2016, 2019, or 2022.
...
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 Modelmodel. 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.
...
The SQL files required for Step 5, Step 6 and Step 7 can be found in the installation kit provided by our helpdesk in the folder Full Upgrade - OnPrem
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.
| Note |
|---|
After executing the first script you will see the warning message Warning! The maximum key length for a nonclustered index is 1700 bytes. The index 'nIdx_Bookings_idx7' has a maximum length of 2052 bytes. For some combination of large values, the insert/update operation will fail. These warnings are expected and can be ignored |
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.
...
When the required edits have been made, execute this script.
Step 7: Repeat the instructions in Step 4 for the remaining file, 03 Qed OnPrem DB Migration SP.sql, with no changes to the content.
...
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….
...
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….
...
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.
...
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.
A more advanced text editor, for example, Notepad++ will offer an easier way of editing the application files than the built-in server tools such as WordPad or Notepad
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:
...
| Code Block | ||
|---|---|---|
| ||
<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.
...
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
| Info |
|---|
Please submit a request to helpdesk@qedas.com to request your licence |
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.
...