• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2613
  • Last Modified:

SQL Server Reporting Services Report Deployment Problem

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.
[Microsoft.ReportingServices.SemanticQueryDesign]

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.
0
PhilipR
Asked:
PhilipR
  • 2
  • 2
1 Solution
 
nicolasdiogoCommented:
hi,

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

see this:
http://www.checkupdown.com/status/E407.html

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

regards
0
 
PhilipRAuthor Commented:
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.

Phil
0
 
nicolasdiogoCommented:
OK

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

have good weekend
0
 
PhilipRAuthor Commented:
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.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now