Rotronic RMS Forum
HOME
Home > RMS Software

Using SQL with Windows Authentication

Thread #252 | 2019-03-22 12:35 UTC | Guest | replies: 1
Post #1 | 2019-03-22 12:35 UTC | Guest
how to use SQL with Windows Authentication?
Post #2 | 2019-03-22 12:35 UTC | Guest
Application Pool Identity
  • Open IIS Manager
  • Select your Application Pool
  • Select "Advanced Settings"
  • 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 file "connections.config" (Use your server and database name):
<add name="DataContext" providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=RMS;Integrated Security=True"/>

No matching posts in this thread.