SQL Server Logon.aspx is always shown

[powerbinuebii]

Hi, everyone.

I have used the sample, however, Logon.aspx is shown with every request.

I set the forms cookie manually in the code, when I hit Logon.aspx the user is authenticated, however, the logon.aspx is shown anyway.

The url looks this way: serverName/ReportServer/logon.aspx?ReturnUrl=/ReportServer/localredirect?url=%252fReports.

An it goes again and again.

Does anyone know how to fix this issue?

Thank you

[cfitzg]

I've run in to this in an earlier version of SSRS (2014?). in my case it was just a typo and not following the sample to a "T".

If you are 100% that you have no config typos and all is in place as per the Sample Instructions, then I would locally debug this if/else on the Login.aspx.cs code-behind:

        if (passwordVerified)
           FormsAuthentication.RedirectFromLoginPage(txtUser.Text, false);
        else
           Response.Redirect("logon.aspx");

...and maybe consider changing the 2nd Redirect parm (bool PersistantCookies) to true instead of false.

*in web.config of /ReportServer directtory- this is the line that tells SSRS to go to your custom Login.aspx page for auth (instead of using Windows/NTLM auth):

<authentication mode="Forms">
    <forms loginUrl="logon.aspx" name="sqlAuthCookie" timeout="60" path="/"></forms>
</authentication> 

...make sure that is all good with no typos, etc.- might just be missing the sqlAuthCookie cookie due to accidental typo.

[kiran-kumar-thatikayala]

Hi, I ran into the an issue. I see error:

he permissions granted to user '*****' are insufficient for performing this operation. (rsAccessDenied) Get Online Help

I tried logging back in but the 'Settings' are now grayed out.

Any help you can provide.