Post reply

blank screen when using http://servername/Reports

  • April 10, 2015 at 11:36 am

    #398307

    Hello

    I've seen a number of posts on this topic but I'm struggling to get to the bottom of it

    I've installed SQL Server 2014 and can't seem to get SSRS working correctly.

    Inputting http://localhost/Reports just returns a blank page

    I've been into RS Configuration Manager and it looks fine

    Security looks good, if I run a test connection, it passes

    If I follow the URL, again a blank screen

    Tried IE, Chrome and Firefox

    Reading around, the suggestion seems to be security

    I am an admin and have installed as an admin

    Does anybody have a suggestion?

    Thanks

    Damian.

    - Damian

  • April 10, 2015 at 2:47 pm

    #1790303

    Have you tried http://<your actual server name>/Reports ? I think I have seen this in the past and, for some reason, localhost was not working.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • April 10, 2015 at 3:06 pm

    #1790308

    Did you try to open IE with administrative rights?

    This is needed when if you are trying to open reports on same server where instance of SQL server is running.

  • April 11, 2015 at 6:02 am

    #1790350

    Thanks for the response

    I finally got this to respond i.e. something other than a blank screen, by applying encryption through RS configuration manager.

    I now get:

    The permissions granted to user '' are insufficient for performing this operation. (rsAccessDenied)

    Any further thoughts?

    Thanks

    - Damian

  • April 14, 2015 at 4:17 am

    #1790711

    Ville-Pekka Vahteala (4/10/2015)

    Did you try to open IE with administrative rights?

  • April 14, 2015 at 5:15 am

    #1790731

    ok, I've found the answer and it seems to be a combination of things.

    Via Reporting Services Configuration Manager Add an additional HTTP identity for both the web Service URL and Report Manager URL.

    Set Host Header Name to localhost

    Set TCP Port to 8080

    Note, I also found that 80 clashed with Skype causing a 'Page cannot be displayed' error

    Although I have amended my Skype setting, I also amended the SSRS port

    I'm not sure how crucial this is but it worked for me

    Through Control Panel

    Search for UAC, select Change User Account Control Settings

    Amend to Never Notify

    I am uncomfortable with this but have found no other way of getting this to work.

    Thanks

    - Damian

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

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