Setup Connection Configuration for wPage

<< Click to Display Table of Contents >>

Navigation:  Software Overview > RMS Monitoring Software > Server Software Installation > RMS Software V1.3.1 > RMS V1.3.1 Installation using MS Windows Server 2019 & MS SQL 2014 > Installation of the RMS Software >

Setup Connection Configuration for wPage

Step 1

Move the extracted .ZIP file from the Desktop and save the folder to the following path on the server: C:\\inetpub\wwwroot\rms\{Version}.

 

remote desktop install 39

 

Step 2

Open the "C:\inetpub\wwwroot\rms\18260\wPage" file.

 

remote desktop install 40

 

Step 3

Open the "XML Configuration" File: connections.config with wordpad/editor.

 

remote desktop install 41

 

Step 4

The following information in the connection string must be modified based upon the settings added to creation of database and the database instance:

 

The following information in the connection string must be modified:

 

   <add name="DataContext" providerName="System.Data.SqlClient" connectionString="Data Source=.\xxx;Initial Catalog=xxx;Persist Security Info=True;User ID=xxx;Password=xxx" />

 

 

1.Data source is the database instance. SQLEXPRESS as used here: Installation and Configuration of the SQL Server Express. This must be adapted, when external SQL database is used. For example:

oDatabase instance name: InstanzName

oDatabase server: 12.34.56.789

oData source = 12.34.56.789\InstanzName

 

2.Initial catalog:
Name of the database. "RMS" as used here: Creation of a New Database Instance.

 

3.ID
User ID for database access of the software. "rmsUser" as used here: Creation of a New Database Instance.

 

4.Password
Password for database access of the software. "Rotronic123" as used here: Creation of a New Database Instance.

 

If every step has been done based upon this manual, simply copy and past the following string:

 <connectionStrings>

   <add name="DataContext" providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLRMS;Initial Catalog=RMS;Persist Security Info=True;User ID=rmsUser;Password=Rotronic123" />

 </connectionStrings>.

 

remote desktop install 42