Ever since the first release of the SSO module (back in Dec 2006), I often received inquiries related to module setup.  The common questions have been:

1. How to edit the web.config to add the connection string to point to the external database?
2. Where to deploy the sql scripts to support SSO?
3. How to import external users into DNN?
4. How do I test the module?

The ICPC-SsoXP version 08.01.05 addresses the above common questions.  In this release, you will no longer need to touch the web.config file.  The connection string setting is now moved to the module Settings page.  By default, it uses the DNN connection string which points to local DNN database.

As part of the installation, the tables and store procedures supporting SSO are deployed in the DNN database.  The tables and store procedures are pre-fixed with TE_SsoXP and pTE_SsoXP respectively.  The sql installation scripts setup about 200 test acounts in the two table TE_SsoXP_Authentication and TE_SsoXP_UserImport so you can start to test the SSO login and users import features right after the module upload.

After installing the module, open table TE_SsoXP_Authentication and get some accounts to test login.  For example use account (alan0, 470689086)  to test login.  After login, update user password or profile data using the SsoXP Profile control.  Verify that the changed data are propagated back to to table TE_SsoXP_Authentication. 

You should also try the Import Users utility that comes with SsoXP module.  Using this utility, you can import all users from external databse at once or individual account.  The source of the import records comes from table TE_SsoXP_UserImport.  The Role column in this table spcifies the user's role.  Prior to import, go to the SsoXP module settings page and set the import references (ex. create role, use default password, assign user to existing role, etc.).  Depend on your settings, the module can create roles, if the roles not existed, and assign user to roles .

If you ever need to quickly generate 200 test accounts and a dozen or so roles, install the SsoXP and run the Import Users utility.  I use this feature very often when I need to setup accounts/roles to demo our custom modules Issue Tracker (IssueXP) and Timesheet (TimeXP).  I have also recommended this utility to our customers who need to import accounts and roles into DNN. 

How do you configure the SsoXP module to point to external database?  If you are familiar with database, you can try to move the tables prefix with TE_SsoXP and store procedures prefix with pTE_Sso to another MS SQL datatabase.  Then add a connection string in the SsoXP module Settings screen to point to the new database.  This will let you test login using accounts from external database.  I will do a separate blog to show how to (1) add connection string and (2) deploy sql scripts to external database, using the Microsoft sample Adventure database as an example. 

The ICPC-SsoXP version 08.01.05 supports DNN version 4.5 to 4.8.  You can  download it from the Download page.  If you have installed a prior version of SSO, I would recommend to un-install it before installing version 08.01.05.  This  will help to remove un-used files.  Below are screen shots  of the module.

	Login Control Custom control to validate username and password against the external database sync profile data between external db and DNN for validated users after login Customizable warning message Display IP of of the user
	Manage User Credentials Sync name and email between DNN and External database when update
	Manage Password Sync password between DNN and External database when update
	Manager Profile Sync profile data between DNN and External database when update
	Import Users Import all accounts or individual Create new accounts if not existed Update accounts if existed Create new role and assign users to new role
	Module Settings/SSO Settings Role based page redirect Import settings Auto assign to role when import Create role Use default password if blank

Fuji Nguyen
InDyne Inc/Chief Technology Officer
fnguyen@hq.indyneinc.com
703-903-6900