Starting with SsoXP version 08.XX, the installation package installs database objects supporting SSO into the DNN database.  This allows to test the SsoXP module right after the installation.  Table below lists the two tables and five store procedures setup in the DNN database.

Name	Type	Description
TE_SsoXP_Authentication	Table	Table with sample user accounts.  Each username is unique in this  table.  The username and password in this table are used to support login to DNN using user accounts from external data source.
TE_SsoXP_UserImport	Table	Table with sample import accounts/roles.  Username and role columns make up unique key.  Records in this table can be mass imported into DNN.
pTE_SsoXP_AuthenticationGet	Store Procedure	Call by the program to validate username and password against the table TE_SsoXP_Authentication
pTE_SsoXP_AuthenticationSelect	Store Procedure	Select unique record from table TE_SsoXP_UserImport to support import of one record at time
pTE_SsoXP_AuthenticationUpdate	Store Procedure	Sync data between DNN and table TE_SsoXP_Authentication when user making changes to the profile online
pTE_SsoXP_PasswordUpdate	Store Procedure	Sync the password between DNN and table TE_SsoXP_Authentication
pTE_SsoXP_UserImportList	Store Procedure	Select all records from table TE_SsoXP_UserImport for mass import into DNN

 

To configure the SsoXP to point to your own database, you need to create store procedures with matching names in your external database.  The store procedures should be modified to point to the table in your external DB that provide similar data as the  original two table TE_SsoXP_Authentication and TE_SsoXP_UserImport.  Then in the SsoXP module setting screen, specify a connection string to point to you external database.

To have SsoXP module to use the  external db, setup matching store procedure name in the external DB Add connection string in the module settings to point to external db