I am using DNN 04.09.00 source version.
I have created three roles and assigned all three Administrators role.
I also cleared browser's cache but but this is also not helful.
I have changed two files code to implement common login for all sites.
In file "Website\admin\Authentication\Login.ascx.vb"
And procedures are (green marked in above code where these procedures are using)
To get PortalId--
ALTER PROCEDURE [dbo].[aa_GetPortalId]
@UserName varchar(100)
AS
BEGIN
SELECT UserPortals.PortalId
FROM UserPortals INNER JOIN
Users ON UserPortals.UserId = Users.UserID
where Users.Username=@UserName
END
To get sub site name
ALTER PROCEDURE [dbo].[getSubSiteName] --getSubSiteName 0
@intPortalId int
AS
BEGIN
SELECT [PortalID]
,[PortalName]
from Portals where [PortalID]=@intPortalId
END
Please advice what is wrong????