Reports will not render from local server

  • This one is an odd one and has me baffled, so any suggestions would be greatly appreciated.

    I have SQL Server and SQL Reporting Services running from a local machine on which I want to develop and deploy. The local machine has Internet Explorer 8 (we are locked to this as a company because of incompatibilities with some intranet sites).

    The services are running perfectly and I can get the SSRS dashboard up, but can do nothing with it. It will not let me create folders, upload files or change permissions. It will go into the appropriate screen (i.e. Create folder will let me enter a name and description), but clicking the OK button does nothing at all, whilst Cancel will take me back to the dashboard.

    I can deploy reports and data sources from BIDS, but cannot upload them using the dashboard.

    When I select a report, it will run all the queries (I can see this using the profiler), and any parameters that build themselves from queries are populated, however nothing renders in the main area for the report.

    I can happily use the same browser to render reports on our development and production report servers with no issues.

    The odd thing is that if I call up FireFox (latest version) and direcdt it to my local reporting services dashboard, it gives me full functionality and I can render the reports.

    I have tried turning the compatibility mode on and off and this hasn't worked, but I am baffled as to why IE8 will render the production and development servers, but not my local server.

    Any suggestions as to what to try would be gratefully appreciated.


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • Did you run IE as administrator?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Yes, just double checked. Closed all instances of IE, ran a new instance as an administrator, same issues.


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • Rayven (10/28/2014)


    Yes, just double checked. Closed all instances of IE, ran a new instance as an administrator, same issues.

    This is the point where people start to use Firefox 😀

    I have something similar here: I cannot go to the production site of MDS with IE, but I can with Firefox.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Yeah, tell me.

    I have one question you may be able to answer. When I connect using fireFox it asks me for my network credentials before continuing. Any idea whether this can be bypassed?


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • No, not exactly. Maybe you can store the credentials in the vault in the user options of your OS?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Found a solution to the fireFox authentication issue

    Type about:config into the address bar and click on the button to bypass the warning.

    find the entry that reads network.automatic-ntlm-auth.trusted-uris and add the path to the reports folder (i.e. http:\\server:80\Reports) to the list of URIs, comma delimited.


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply