Documentation

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
borderColor#000000
bgColorwhite
titleColorwhite
titleBGColor#000000
borderWidth1
titleIntroduction
borderStylesolid

Use this guide along with the Data Tab Configuration guide to configure a ODBC-integrated SecureAuth IdP realm. 

Panel
borderColor#444443
bgColorwhite
titleColorwhite
titleBGColor#444443
borderWidth1
titlePrerequisites
borderStylesolid

1. Have an on-premises ODBC data store

2. A service account with read access (and optional write access) for SecureAuth IdP

Panel
borderColor#135570
bgColorwhite
titleColorwhite
titleBGColor#135570
borderWidth1
titleODBC Configuration Steps
borderStylesolid
Section
Column
width50%

Image Added

Column

 

1. In the Membership Connection Settings, select ODBC from the Data Store dropdown

2. Provide the Fully Qualified Domain Name (FQDN) or the IP Address in the Data Source field

3. Provide the Database Name in the Initial Catalog field

4. Select True from the Integrated Security dropdown if the IIS app pool's service account is to be used in the connection

Select False to specify a SQL service account instead

5. Select True from the Persist Security Info dropdown if access to the username and password information is allowed

6. Provide the User ID of the SecureAuth IdP Service Account (if False is selected in step 4)

7. Provide the Password associated to the User ID (if False is selected in step 4)

8. Click Generate Connection String, and the Connection String will auto-populate

9. Select how the Service Account Password is to be stored in the directory from the Password Format dropdown

10. Create a list of Allowed Groups that can access the target resource of this realm, e.g. Admins

11. Create a list of Denied Groups that cannot access the target resource of this realm

12. Provide the Stored Procedure Name for Get User SP

13. Provide the Stored Procedure Name for Reset Password SP

14. Provide the Stored Procedure Name for Create User SP

15. Click Test Connection to ensure that the connection is successful

Info

Refer to Data Tab Configuration to complete the configuration steps in the Data tab of the Web Admin