Post reply

SSRS Connection Issues

  • July 21, 2009 at 9:33 am

    #202700

    I've got new SQL2005 install on Server2008 with the SSRS service running as a user with admin rights on the box. When I try to connect to SSRS (both as the service account and myself, both SQL sysadmins) I get "No connection could be made because the target machine actively refused it :443".

    When I try to go to http:///Reports/ in a browser, I get "unable to connect to the remote server".

    When I go into the Surface Area configuration, and click on the "Windows Integrated Security" under "Reporting Services", it pops up a message that says "The request failed with HTTP status 403: Forbidden. (SQLSAC)".

    Can anyone think of something obvious I'm missing? I've got Windows Firewall totally turned off.

    The Redneck DBA

  • July 21, 2009 at 9:39 am

    #1027717

    what is the status of IIS?

  • July 21, 2009 at 9:45 am

    #1027724

    It seems to be OK.

    I get a decent looking error screen and not just a nasty 404 page or something, and if I just go to http:/// I get the IIS7 "welcome screen" (or whatever it's called).

    I also made a dummy "test" site and slapped up a "Hello World" HTML page and that works OK.

    The Redneck DBA

  • July 21, 2009 at 9:52 am

    #1027728

    Is this the first time you are logging to SSRS?

    Check if you have already configured reporting services at

    All programs-->SQL 2005-->Conf. tools-->reporting services conf.

    You should see all ticks there.

  • July 21, 2009 at 9:58 am

    #1027739

    I haven't set up share point integration or the e-mail settings, or backed up the encryption keys, but I wouldn't think those would stop it from working. Everything else has a green check by it.

    The Redneck DBA

  • July 21, 2009 at 10:29 am

    #1027774

    Is this the first time you are logging?

    if IIS is fine:

    looks like you need to review ssrs configuration:

    Reporting Services Configuration Tool

    http://msdn.microsoft.com/en-us/library/ms156305(SQL.90).aspx

    also

    Troubleshooting Reporting Services

    http://msdn.microsoft.com/en-us/library/ms159135(SQL.90).aspx

    may be try this:

    Change the Reports / ReportServer virtual directory properties for the Application Pool from defaultapppool to the ReportServices pool. Restart IIS , clear IIS cache and

    http://localhost/reports - finally came up !!!

  • July 21, 2009 at 11:28 am

    #1027818

    Thanks for the links.

    I finally gave up and just went thru each of the little steps in the report server configuration tool and clicked the 'apply defaults' button. (which is what I thought I did to start with).

    It still didn't work, so just for fun I rebooted the server, and when it came up it magically worked.

    Thanks!

    The Redneck DBA

  • July 21, 2009 at 12:10 pm

    #1027829

    Jason Shadonix (7/21/2009)

    It still didn't work, so just for fun I rebooted the server, and when it came up it magically worked.

    Thanks!

    😀 following the old motto, when everything else fails, reboot.....

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

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

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