Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Both Web service URL and Report manager URL does not work

Answered Both Web service URL and Report manager URL does not work

  • Friday, January 18, 2013 6:09 PM
     
     
    Sign In to Vote
    0

    I have installed SSRS 2012 on Windows 2008 R2. This window server also has IIS 7.0 and SSL. The URL is using FQDN. Both web service URL and report manager URL does not work.

    When I click on each of these URLs, a login window will pop up asking for a password. After three login attempt, the login box will disappear and then I will see a blank white page.

    I have been working on this problem for a few days. Any help will be greatly appreciated.

    Thanks

    MK

     

All Replies

  • Friday, January 18, 2013 6:16 PM
     
     
    Sign In to Vote
    0

     a login window will pop up asking for a password.

    Hello,

    Since SSRS 2008 it don't uses IIS, SSRS has it's own http.sys to host the web gui.

    If you get a login prompt, then because you don't have permission to logon to SSRS; that's let's say "normal" (unfortunatly). If you are a local admin on the server, then please start IE with "Run as Administrator" by right-mouse-click on the IE icon. Navigate to the Report Manager URL, goto "side settings" (on top right) and goto tab "Security", add there your account to the "System Administrator" role. Afterwards you should be able to logon

    Olaf Helper

    Blog Xing

     
  • Friday, January 18, 2013 6:59 PM
     
     
    Sign In to Vote
    0

    Hello Olaf,

    Thanks for responding to my posting. However, I am having problems following you propose solution to my posting. I am a local admin to the windows server.

    Steps:

    Start Run
    IE as an administrator.

    Navigate to
    the Report Manager URL. The URL is in the Report Server configuration manager, not IE.

    When I click on the URL in reporting manager, I get the login window asking for password, no option to change settings. I don't see a security tab as well as an option to add my account to the system administrator role.

    Could you please clarify these steps? They are confusing.

    Regards

    MK




    • Edited by Momentum101 Friday, January 18, 2013 7:01 PM
    •  
     
  • Saturday, January 19, 2013 1:39 PM
     
     
    Sign In to Vote
    0

    Can someone please help? This problem still has not been resolve.

    Regards

    MK

     
  • Tuesday, January 22, 2013 5:47 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Momentum101,

    Based on the scenario, the problem is due to Kerberos authentication. Kerberos is an authentication protocol that allows clients that create authentication tokens to associate a specific destination to that token.  In the failure case there is a mismatch between the destination specified in the token and the report server process configuration. Due to this mismatch, the underlying Kerberos authentication scheme supported by Windows prevents report server from authenticating the user.

    To resolve the issue, use the following steps:

    • If you use Kerberos authentication, you can either change the Reporting Services Service Account to Network Service, or register the SPN for the report server. For the detailed information, please see:
      Register a Service Principal Name (SPN) for a Report Server
    • If you don't use Kerberos authentication, remove RSWindowsNegotiate and ensure RSWindowsNTLM is specified in the file RSreportserver.config. The RSreportserver.config file is located in the <Drive>:\Program Files\Microsoft SQL Server\MSRS11.<Instance Name>\Reporting Services\ReportServer folder. Please back up the config file before makeing modifications to it.

    Reference:
    Solving the Reporting Services Login issue in the February CTP of SQL Server 2008

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here

    Mike Yin
    TechNet Community Support