SQL with Windows Authentication Only

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

SQL with Windows Authentication Only

If SQL authentication is not allowed, then use SQL with Windows authentication.

 


Description

Step 1

Using the Windows search function open Internet Information Services (IIS) Manager app.

 

 

Application Pool Identity

oOpen "IIS Manager"

oSelect your Application Pool

oSelect "Advanced Settings"

oUnder "Identity", select "Custom Account" and provide a User and Password for an account with access to SQL Server

 

clip0053

 

Connection String

Edit the RMS connection string in the file "Connections.config" (Use your server and database name):

   <add name="DataContext" providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLRMS;Initial Catalog=RMS;Integrated Security=True"/>

 

clip0139

 

The RMS Server Service is now connected to the database.

 

remote desktop install 44