RM Studio Web Site Installation Guide

Prerequisites:

• A web server capable of hosting the RM Studio website (see the requirements here)
• An up to date RM Studio database that is accessible from the web server
• A valid RM Studio License Key with Web Module enabled

Installation steps:

Set up an Application Pool for the RM Studio website.

1. Open up IIS Management interface and find the application pool configuration section, and add a new Application pool:

2. Choose a name for the Application Pool and configure it for .NET Framework version 4 and Integrated Pipeline:

3. Find the Advanced Settings for the new Application Pool

4. Make sure to set Enable 32-Bit Applications to True. Here you also need to configure the Identity of the account that runs the Application Pool. Typically this will be the default ApplicationPoolIdentity, or a domain service account.

After setting up the Application Pool, you can proceed with deploying the RM Studio website:

1. Download the RMStudio.Web.zip installation package

2. Create a new folder on your web server to host the website. In this example we will use C:\Inetpub\wwwroot\RmsWeb\

3. Extract the contents of the installation package into the new folder

4. Open the RMStudio.lic file in the new folder and paste in your RM Studio license key

5. Open up IIS Management interface

6. Find the new folder in the directory structure and convert the website folder to an application:

7. In the configuration window, select the Application pool you created earlier:

The next step is to configure the database used for the RM Studio website. NOTE: Microsoft SQL Server Local DB can not be used as a database for the web module. SQL Express or higher is required.

1. Browse to the folder you created to store the RM Studio website files and open up the ConnectionStrings.config configuration file in a text editor:

2. You will see the <connectionStrings> configuration element, and within it a placeholder connection string for you to fill in:

Input the correct connection string for your RM Studio database between the quotes in the connectionString attribute. Make sure to remove the { } braces.

The connectionString can take the following forms:

• Using Integrated Security (Domain authentication), using the domain account specified in the Application pool identity:

Server={ServerName}; Database={DatabaseName}; Integrated Security=true

Example:  Server=SqlExpress; Database=rmstudio; Integrated Security=true

• Using a custom account to authenticate with the database:

Server={ServerName}; Database={DatabaseName}; Integrated Security=false; User Id ={UserName}; Password={Password}

Example:  Server=SqlExpress; Database=rmstudio; Integrated Security=false; User Id=MyDomain\ServiceAccount; Password=ServicePassword123

If needed, grant the required login privileges on the SQL Server database.  In the example below, we will add the default Application Pool account as a login.

1. Open SQL Server Management Studio and connect to the database instance hosting the RM Studio database.

2. Under the Security node and Logins, add a new Login:

3. In the Login Name field, manually enter the name of the Application Pool as: „IIS APPPool\RmsWebPool“ (Replacing RmsWebPool with the name of the pool you created – Without the quotes).

Make sure you DO NOT click the Search button – simply type in the name of the application pool and leave it like that.

4. Navigate to the User Mappings node. Find your RM Studio database in the list:

• Check the „Map“ column in the upper list
• User name should be the name of the login (from step 3)
• Default Schema  should be „dbo“
• In the roles list, check the „db_owner“ role

Click OK to save the new login.

This should conclude the installation steps. To test the web site, open up a browser on the server and navigate to http://localhost/RmsWeb (or where your installation is located). You should be presented with the RM Studio login form. You can log in using any user account defined in RM Studio, either with Windows Authentication or RM Studio user authentication.