Hi There,
I've just purchased Dynamic Login to try and get cross portal SSO working. However I have hit an issue almost immediatly.
DNN is version 5.4.1, and the latest DL 3.3 (DR4 is also on this portal)
I have kept all the default settings when setting up the module apart from turning on SSO ,setting the default portal, and turning on sync for every login.
When I log in as a user who as yet doesnt exist in my new portal I get a critical error: Invalid Object 'UserRoles'
The trace from the log viewer is a bit more descriptive:
DotNetNuke.Services.Exceptions.PageLoadException: Invalid object name 'UserRoles'.
---> System.Data.SqlClient.SqlException: Invalid object name 'UserRoles'.
-- trim not useful stuff --
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues)
at DataSprings.DNN.Modules.DynamicLogin.Data.SqlDataProvider.SyncUserRolesBetweenPortals(Int32 intMasterPortalID, Int32 PortalID, Int32 intUserID)
at DataSprings.DNN.Modules.DynamicLogin.Business.DynamicLoginController.SyncUserRolesBetweenPortals(Int32 intMasterPortalID, Int32 PortalID, Int32 intUserID)
at DataSprings.DNN.Modules.DynamicLogin.DynamicLogin.UserLogin() at DataSprings.DNN.Modules.DynamicLogin.DynamicLogin.Page_Load(Object sender, EventArgs e)
-- trim more not useful stuff --
After closer investigation it looks like it maybe the storedproc :
DataSprings_DynamicLogin_SyncUserRolesBetweenPortals
I am guessing the error is that my database has a tableprefix ( {objectQualifier}) of taxclub_ and not all of that stored procedure has the objectqualifier in. (specifically the section just below the comment: -- insert user role into child portal)
I could try and work round this, but not 100% exactly sure exactly what needs to be in that storedproc, so is there any chance you could look into it for me please?
Regards,
Andy.