none
Report Manager 2008 r2 - prompts for username/password & does not accept

    Question

  • Hi all,

    I am dealing with an extremely frustrating problem with Reporting Services 2008 r2, Report Manager, and would greatly appreciate any help.

    I have installed Reporting Services, with Report Manager, onto a Windows Server 2008 r2 install. 

    When loading Report Manager (http://server/reports), I get prompted for a username/password.

    No matter what I type in, I get prompted a 2nd time, then a 3rd time, then a blank screen loads up.

    @#$@#??!?!!

    How can I get past this username/password challenge - remember this is SQL 2008 r2 so IIS-based solutions are not relevant.

    Thanks again,

    Jason

    Tuesday, August 10, 2010 8:41 PM

Answers

All replies

  • Hello Jason,

    When a prompt appears, then you (your account) don't have the permission to access Reporting Services.

    Logon as administrator to the machine where SSRS is installed. Then start Internet Explorer explicit with "Run as Administrator" (required for vista/win 7/win 2008) and then goto the report manager side. There you can add your account + rights.


    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    Wednesday, August 11, 2010 5:28 AM
  • Actually my account is a local administrator on the box, and is also listed within Report Manager as both Administrator and User.

    Again it works fine when connecting locally - I do not need to "Run As Administrator" (I did before, but I fixed that).

    Now, it is only when I connect from another machine on the network, that I get the three Username/Password dialog boxes that literally does not care what I type in before directing me to a blank page.

    Wednesday, August 11, 2010 11:09 PM
  • Hi Jason,

    Did you follow the solution i mentioned at another your thread http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/4f3651cb-c608-4460-a45a-9337df2ab88a ? This is very common issue in SSRS 2008 and the solutons have been summarized at this blog http://blogs.msdn.com/b/lukaszp/archive/2008/03/26/solving-the-reporting-services-login-issue-in-the-february-ctp-of-sql-server-2008.aspx , and also applies to SSRS 2008 R2.

    Note:by using the default installation, the rsreportserver.config file is stored at C:\Program Files\Microsoft SQL Server\MSRS10_50.instance\Reporting Services\ReportServer

    please let us know the result.

    thanks,
    Jerry

    Thursday, August 12, 2010 3:56 AM
    Moderator
  • Tried all the above, no luck. Been researching this for a few weeks now.

    Interesting thing is, when I make domain\domain users as an administrator on my local PC, they can access Reports Manager...

    Driving me nuts! Any help would be appreciated! Thanks!

    Friday, November 1, 2013 3:41 AM
  • I'm having the same issue. Was this ever resolved?
    Tuesday, June 10, 2014 3:16 PM
  • Was this ever resolved?

    See the post of Jerry and the provided links.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Wednesday, June 11, 2014 6:54 AM