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 INSERT AS BEGIN declare @RoleID int,@OldRoleID int,@PortalID int,@RoleName nvarchar(50) select @RoleID=RoleID,@OldRoleID=RoleID from inserted select @RoleName=RoleName ,@PortalID=PortalID from Roles where RoleID=@RoleID select @RoleID=RoleID from Roles where RoleName=@RoleName and PortalID=@PortalID if @RoleID is not null and @RoleID<>@OldRoleID begin INSERT INTO [dbo].[UserRoles] ([UserID] ,[RoleID] ,[IsTrialUsed] ,[CreatedByUserID] ,[CreatedOnDate] ,[LastModifiedByUserID] ,[LastModifiedOnDate]) select UserID ,@RoleID ,IsTrialUsed ,CreatedByUserID ,CreatedOnDate ,LastModifiedByUserID ,LastModifiedOnDate from inserted end END Go create TRIGGER [dbo].[Users_AddUserPortals] ON [dbo].[Users] AFTER INSERT AS BEGIN declare @UserID int,@CreatedDate datetime select @UserID= UserID,@CreatedDate=CreatedOnDate from inserted INSERT INTO [dbo].[UserPortals] ([UserId] ,[PortalId] ,[CreatedDate] ,[Authorised] ,[IsDeleted] ,[RefreshRoles]) select @UserID ,PortalID ,@CreatedDate ,'1' , '0' ,0 from Portals END 

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