Post reply

Connecting to Reporting Services via SSMS

  • March 11, 2009 at 5:47 am

    #128952

    Hi,

    I am new to using Reporting Services and am having problems connecting from the SSMS.

    When I try to connect using windows authentication I get the following message:

    The request failed with HTTP status 407: Proxy Authentication Required ( The ISA Server requires authorization to fulfill the request. Access to the Web Proxy service is denied. ). (Microsoft.SqlServer.Management.UI.RSClient)

    Has anyone else seen and fixed this?:ermm:

  • March 11, 2009 at 6:31 am

    #957402

    Hi JWALLA4

    Have a look at: http://support.microsoft.com/kb/248020

    Could this help?

  • March 12, 2009 at 9:23 am

    #958426

    You can only connect to reporting services via SSMS on the server SSRS is installed on. No remote connections.

  • March 12, 2009 at 9:37 am

    #958440

    It is working the other way round for me.

    I can connect remotely to SSRS from SSMS on my laptop but when I am on the server I get the message.

  • March 12, 2009 at 10:02 am

    #958470

    Sorry, my brain was thinking SSIS, and I was typing SSRS. I can't help you. GL

  • March 12, 2009 at 12:04 pm

    #958573

    I'm a newbie myself, but I set up everything on my Local server 2008 as "Mixed" Authentication. I was then able to login using Windows or SQL Server authentication. I'm not sure if that addresses your authentication method.

    The SRS Configuration Manager can set up required information in multiple areas for the server.

  • December 22, 2009 at 6:41 am

    #1095366

    Same this side, can connect from SSMS on desktop but not on server logged on as service account.

    Any results?

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

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