Use this guide along with the Data tab configuration guide to configure a SQL Server-integrated SecureAuth IdP realm.
If connecting SecureAuth IdP to SQL Server User Data Store using Windows Authentication, see the SecureAuth SQL Server Windows ID Implementation PDF.
In the Membership Connection Settings section for the Datastore Type, set the Type to SQL Server.
In the Datastore Credentials section, do one of the following:
In the Datastore Connection section, set the following:
In the Group Permissions section, set the following:
In the Stored Procedure Configuration section, provide the stored procedure names for the following fields:
To test the connection, click Test Connection.
If using a Custom Connection String and experience an error when testing the connection, see the Custom Connection String Error section for a workaround.
When a custom connection string is manually entered, an error might occur when testing the connection. This can prevent the SQL server from successfully integrating with SecureAuth IdP.
This error can occur when the Custom Connection String check box selected and the Connection String is manually entered into the field instead of being generated by the Web Admin.
See the following steps for a workaround to this issue.