eRAMP SQL Setting up Windows Authentication

SQL Setting up Windows Authentication

eRAMP SQL users have the option to use Windows Authentication to secure access to their eRAMP SQL database. Follow the instructions below to add Windows Authentication to your eRAMP SQL setup:

From the eRAMP Settings>Client Setup Screen there is an option to activate Windows Authentication.


When this option is checked the connection string will include: Integrated Security=SSPI

​

Complete the following steps if you would like to use Windows Authentication on the SQL Server:


1. Create new Login ERAMP with the SQL Server authentication option and password ERAMP_APP and default database ERAMP.

2. Add new user: ERAMP with Login ERAMP to the ERAMP database users with read/write access

3. To activate Windows Authentication open eRAMP and go to Settings>Client Setup. Check the Windows Authentication checkbox at bottom of screen.


You have completed Windows Authentication setup in eRAMP.

    • Related Articles

    • SSPI Error generated by SQL Server

      The SSPI Error is generated by SQL Server. SSPI is Security Support Provider Interface.   The eRAMP connection string is:       'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=false; Initial Catalog=ERAMP;Application ...

    • Why SQL over Access

      Why SQL over Access: Access utilizes a File Server design while SQL Server employs a Client/Server approach. This is a fundamentally different architecture which has many, many implications. When we refer to Access in this discussion we are really ...

    • Setting up Servicer with different ORG ID During Registration

      Applies to:  All eRAMP Versions Issue:  Lender has a different ORG ID for servicing loans.  Lender needs a one step process to Register loans with the alternative ORG ID. eRAMP Version 11.5.0.0 will allow loans to be Registered with an Alternative ...

    • How to script a SQL Database

      To open the Generate and Publish Scripts Wizard In Object Explorer, expand Databases, right-click a database, point to Tasks, and then click Generate Scripts. ... On the Choose Objects page, select the objects to be included in the script. ... On the ...

    • Make Global Change to SQL County Table

      Problem: Your LOS system has the word county after each county name. When you import into eRAMP county names never match. Cause: The county name from your LOS has to be an exact match to the county name in eRAMP. If the names do not match eRAMP will ...