Relyence User Guide
Use Windows Authentication for SQL Server

Use Windows Authentication for SQL Server

To use Windows Authentication instead of SQL Server Authentication, you must remove the credentials in the connection string in Web.config and set the required Windows credentials in IIS directly.

Remove Credentials from Web.config

This guide assumes you are following the Relyence On-Premise Installation Instructions or Upgrading the Relyence On-Premise Solution and already have Web.config open in Notepad.

  1. In the connection strings for both memberdb and appdb, remove the following section: User Id=sa;Password=!R3ly3nc3!;
    1. Note: if you originally installed Relyence prior to Relyence 2022 Release 2 (July 2022), your password will likely be !R3ly3nc3! or if you originally installed with Relyence 2022 Release 2 (July 2022) or later, your password is likely !R3ly3nc3!R3ly3nc3!
    2. Be sure to remove the trailing semicolon.
  2. In the connections strings for both memberdb and appdb, add the following section before Database: Integrated Security=SSPI;
    1. Be sure to include the trailing semicolon.
    2. Your connection strings should now appear similar to: Data Source=.\Relyence;Integrated Security=SSPI;Database=memberdb;MultipleActiveResultSets=True;
  3. Save your edited Web.config file on your Desktop.
  4. Copy the newly edited Web.config from your Desktop to your installation directory to replace the Web.config file there.

Add Windows Credentials in IIS

  1. Open Internet Information Services (IIS) Manager.
  2. Select Application Pools from the Connections pane.
  3. Select Relyence from the Application Pools pane.
  4. Click Advanced Settings... from the Actions pane to bring up the Advanced Settings dialog.
  5. Under the Process Model heading, find Identity and click the ... button on the right.
  6. Select Custom account in the dialog and click Set.
  7. Enter the user name and password for the Windows user you would like Relyence to use.
    1. Note that your user name may have to contain your domain name and be formatted similar to DomainName\UserName.
  8. Click OK in the Set Credentials dialog, the Application Pool Identity dialog, and the Advanced Settings dialog.
  9. In the Connections pane, expand the Sites section, and then expand the Default Web Site section if not expanded. Select Relyence under the Default Web Site section.
  10. Double click Authentication under IIS in the center pane.
  11. Click on ASP.NET Impersonation and click Enable in the Actions pane.
  12. With ASP.NET Impersonation still selected, click Edit... in the Actions pane.
  13. Select Specific user in the dialog and click Set.
  14. Enter the same user name and password for the Windows user that you used previously.
  15. Click OK in the Set Credentials dialog and the Edit ASP.NET Impersonation Settings dialog.

Return to the Relyence On-Premise Installation or Upgrade Instructions

If you are installing Relyence for the first time, go back to the Relyence On-Premise Installation Instructions and continue with Step 1.3 after the Web.config file has been saved.

If you are upgrading an existing Relyence installation, go back to Upgrading the Relyence On-Premise Solution and continue with Start Relyence.