none
how to Connect to report server through a Proxy Server RRS feed

  • Question

  • I have a VB.NET Application for using sqlserver 2005 reporting services.
    Our client use this Application, but he can't access our report server.
    Because he must use his proxy to internet.

    My question is how to access my report server throuh the proxy.

    This is some code as follow:

                '1. proxy settings
                Dim cache As System.Net.CredentialCache = New System.Net.CredentialCache()
                cache.Add(Proxy.Address, Proxy.Port, "Kerberos", System.Net.CredentialCache.DefaultCredentials(Proxy.UserName, Proxy.Password, Proxy.Domain))

                '2.remote report server
                Me.ReportViewer1.ProcessingMode = ProcessingMode.Remote
                Me.ReportViewer1.ServerReport.ReportServerUrl = New Uri("http://www.mycompanyweb.com/ReportServer") 
                Me.ReportViewer1.ServerReport.ReportPath = "/MyReportFolder/sales"

                'This is my report server Credentials
                cache.Add(New Uri("http://www.mycompanyweb.com/ReportServer"), "NTLM", New System.Net.NetworkCredential(mycompanyweb.UserName, mycompanyweb.Password, mycompanyweb.Domain))
                Me.ReportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cache

                Dim rps(1) As ReportParameter
                rps(0) = New ReportParameter("P01", _S02)
                rps(1) = New ReportParameter("P02", _S03)
                Me.ReportViewer1.ServerReport.SetParameters(rps)

                Me.ReportViewer1.ServerReport.Timeout = 120000
                Me.ReportViewer1.RefreshReport()

    Error message: The request failed with Http Status 407. Proxy authentication required
    --------------------

    Friday, April 20, 2007 9:50 AM

All replies