dnn（dotnetnuke）下如果实现二级域名的单点登录

 

1、编辑web.config文件 修改anonymousIdentification和httpCookies 节点中的domain，加入主域名

<anonymousIdentification enabled="true" cookieName=".ASPXANONYMOUS" cookieTimeout="100000" cookiePath="/" cookieRequireSSL="false" cookieSlidingExpiration="true" cookieProtection="None" domain="xakep.com"/>

 <httpCookies httpOnlyCookies="true" requireSSL="false" domain="xakep.com"/> 

2、执行 下面 的sqlsql 语句， 语句， 创建 两个触发器

create TRIGGER [dbo].[Users_AddUserRoles]ON [dbo].[UserRoles]AFTER INSERTASBEGINdeclare @RoleID int,@OldRoleID int,@PortalID int,@RoleName nvarchar(50)select @RoleID=RoleID,@OldRoleID=RoleID from insertedselect @RoleName=RoleName ,@PortalID=PortalID from Roles where RoleID=@RoleIDselect @RoleID=RoleID from Roles where RoleName=@RoleName and PortalID=@PortalIDif @RoleID is not null and @RoleID<>@OldRoleIDbeginINSERT INTO [dbo].[UserRoles]([UserID],[RoleID],[IsTrialUsed],[CreatedByUserID],[CreatedOnDate],[LastModifiedByUserID],[LastModifiedOnDate])select UserID,@RoleID,IsTrialUsed,CreatedByUserID,CreatedOnDate,LastModifiedByUserID,LastModifiedOnDatefrom insertedendENDGocreate TRIGGER [dbo].[Users_AddUserPortals]ON [dbo].[Users]AFTER INSERTASBEGINdeclare @UserID int,@CreatedDate datetimeselect @UserID= UserID,@CreatedDate=CreatedOnDate from insertedINSERT INTO [dbo].[UserPortals]([UserId],[PortalId],[CreatedDate],[Authorised],[IsDeleted],[RefreshRoles])select @UserID,PortalID,@CreatedDate,'1', '0',0from PortalsEND 

以上 完成 后， 新注册 的用户 就可以 单点登录 了（ 仅支持 二级 域名 的单点登录 ）