Using SQL with Windows Authentication

<< Click to Display Table of Contents >>

Navigation:  Help > Installation >

Using SQL with Windows Authentication

In some places, SQL authentication is not allowed.

 

Application Pool Identity

Step 1

Open IIS Manager

Step 2

Select your Application Pool

Step 3

Select "Advanced Settings"

Step 4

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

 

 

Connection String

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

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