SQL Server Reporting Services Report Deployment Problem

Posted on 2007-10-03
Last Modified: 2013-12-12
A developer in my organization is trying to deploy SQL Server Reporting Services objects to a report server and receives the following error:

A connection could not be made to the report server http://modapptest/ReportServer$SQL2005.
The request failed with HTTP status 407: Proxy Authentication Required.

I believe he has all the necessary permissions to deploy reports.  In fact, I tried giving him admin rights on the server and he got the same results.  He is doing this from a VM.  Other developers are able to deploy reports, including one who is running on a VM.
Question by:PhilipR
    LVL 5

    Expert Comment


    excuse me for stating the obvius but you do not have a sql problem.
    you have a proxy authentication problem.

    see this:

    you need to make that users are able to load pages from your reporting server.


    Author Comment

    Nicolas -

    Thank you very much for your response.  With a holiday coming up on Monday and other priorities, we may not be able to implement any changes until the end of next week, but we'll let you know the outcome as soon as we do.

    LVL 5

    Accepted Solution


    but ask your network admin to tell you how users login to your proxy.
    that is where you have problem

    have good weekend

    Author Comment

    So far, we have tried two things:
    1.  We contacted our Network Operations department and they told us that they allowed access to the URL (through Blue Coat) required by the SSRS deployment process, but we're still getting the same error.
    2. The user can load pages from SSRS.  He was able to open a report that we had previously deployed, but he can't deploy one himself.

    I'm not sure where to go from here to diagnose exactly what the problem is.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Let’s list some of the technologies that enable smooth teleworking. 
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
    The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now