.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Report Builder 3 not connecting to the server

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server
I have some SSRS reports that I am looking to use Report Builder 3 with them.
Currently I was moved to a new laptop. The problem I am having is that the connection to the server from the report is not working, I am getting this message:
"Connection failed. Unable to connect to the server specified URL // www. etc"

I have access to this server via VPN and Remote desktop.

I need someone who can explain the reasons are why this is failing.

Report Builder 3 R2, SSRS, SQL Server 2008

View Complete Post

More Related Resource Links

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

Error connecting to Remote report server database in SQL Server 2008 R2 DataCenter Edition

I am trying to configure my report server installed on Server A to point to a reporting services DB on Server B. I am able provide the name and test the connection. However, when i click next on the configuration wizard after providing the Server A name I am receiving the below error: The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services I have SQL Server 2008 R2 DataCenter Edition on both the servers.    

Server 2008 R2 64 bit, SSRS 2008 64 bit with Report Builder 3.0 issues with Oracle OLE Driver

Folks, ran out of idea on this issues. Setup as shown at the Title. I can connect via VS 2010  but report builder cannot run properly when setup with connection string. I use a 32 bit Oracle Driver and VS 2010 works well with it, however, Report Builder on SSRS report a bad image issues while attempting to use the same driver. What have been tried: 1-Already attempted to try to download Oracle ODP drivers 64 bit, but current driver 11g and minor version above 11g does not install, installation failed. So far all chats indicated that Server 2008 R2 does not have a Oracle 64 bit driver provided y Oracle. Any help is appreciated ....    

Report builder 3.0 - Unable to connect to server

Hi there, We've been using Report Builder 2.0, and its been working pretty nicely. We have the option 'Use this report server or sharepoint site by default' option set to http://<server>/reportserver - and users can connect via the 'Open' dialog, save, etc. However, some of our users have been testing Report Builder 3.0 - and they are unable to connect, even though the URL is set exactly the same.  They have Report Builder 2.0 and 3.0 installed on the same client workstation. With the same settings, 2.0 can connect, but 3.0 can not. The target installation is SSRS is SQL 2008. The error is: Connection failed. Unable to connect to the server that is specified in the URL... Make sure that the server is running, the URL is correct and you have permission to use the server. Does anybody have any ideas? thanks, mark

Default values for filters not populating in report builder (SQL server 2005)



I  am frustrated with this challenge for  populating default values for filters in report builder. Here are the steps that I am performing.

I have clicked on the filter icon, then dragged the dimension to the filter pane, switched the properties to Prompt and changed the operator to 'in this list'.

 by default the value selected is 'no value selected', Microsoft online tutorials says that this should automatically populate the filter criteria with the default list of values for the underlying dimension. However it dosen't

How do I populate this filter with default list of values.

Please help.










Report Builder 3.0 Compatibility with SSRS and Sql Server 2008 (not R2)

I've built reports in Report Builder 3.0 (which I love!). I tried to deploy the reports to an instance of SSRS installed with SQL Server 2008 (not R2). I can't deploy the reports - it appears SSRS is not forward compatible with Report Builder 3.0 reports. Would SQL Server 2008 SP1 help? Is there anything I can do to use Report Builder 3.0 with SSRS 2008?

Unfortunately, I cannot install SQL Server 2008 R2 in the production environment (yet).

Report Builder 3.0 unable to access SharePoint Foundation 2010 Report Server


I am having a terrrible time getting this to work. I have configured the SharePoint site and the SQL Servers involved to use Kerberos. That has been confirmed working.

I then configured the SharePoint site's Reporting Services integration (trusted account), enabled anonymous access and enabled report builder. I can launch report builder without any issues at all. The problem comes when I try to save my report. When Report Builder is started Items->New-ReportBuilder Report it opens and display in the lower left hand corner "No current report server." When I close the Wizard dialog and click connect I enter http://server.fqdn.net and I receive the following error:

Connection failed:

Unable to connect to the server that is specified in the URL, 'http://servername.fqdn.net/'.

Make sure that the server is running, the URL is correct, and you have permission to use the server.

I have also tried http://servername.fqdn.net/reportsserver/. When I try that I receive a login prompt. When I enter my credentials it tries for a few seconds and then sends another login prompt. I installed the report server using default settings. The reporting services db is on the same server as sharepoint. The configuration and other databases are on a remote S

SQL Server 2008 R2 Report builder - Cannot update a list of fields for the Query



I have existing report connected to SSAS cube. When I try to change the query and click OK, i get this message "Could not update a list of fields for the query. Verify that you can connect to the data source and  your query syntax is correct"

My Query syntax and access to data source dont have any problem.  Because fo this issue, i cannot update the query used in the report. How do i resolved this issue?



Problem connecting to report server from client machine


We've deployed some reports from a server machine which can be accessed without any problems if you are logged onto the server itself by going to the URL of http://servername/ReportServer. However if we try and access the reports from a client machine (even if we use the same administrator Windows account) we get the Windows security window appear asking for a Username and Password to be entered in order to connect to the server. We've tried entering this but we then just get a blank screen after being re prompted a few times to enter the details.
Now I'm not sure whether this will be a Reporting Services or a Windows issue. Could it be a setting within IIS? It can't really be a user thing as the same user works on the server but not on the Client machine so it's more of a machine problem. It's as if there are some authentication settings somewhere that need to be set.
We are using SQL Server 2008 on Windows 7.
Thanks a lot

SQL Server 2008 r2 Report Builder 3 problem with "landscape" orientation


 I am trying to format a report that is oriented in 'landscape'.  I have set the report properties page setup for 'landscape' but the program formats the report in 'portrait' mode.  The program recognizes the margin settings but does not recognize the 'landscape' orientation.  Has anyone else had this problem?

SQL Server report builder 2.0 in proxy environment



We are using SQL Server report builder 2.0 for our adhoc reports module.

Our client uses a proxy environment for their internet.

While the report builder 2.0 works perfectly well for us, we have a problem at the client's place.


When users try to access the report server, it returns the error message "Unable to connect to the report server http://<URL>!"


I have tried all sorts of settings in the MSReportBuilder.exe.Config file but it does not seem to work.

The proxy settings I tried is as follows:

      <defaultProxy enabled="true" useDefaultCredentials="true">

NOTE: The script location is masked to keep the confidentiality of the client i.e., the client name is replaced with ??? characters. This is the exact address stated in the Internet explorer connection.

It still does not

how to connect report server from report builder?


last time I asked, but no one answered, since the db is in sharepoint integrated mode, now I use native mode, still cannot connect it, it keeps asking me the user name and password. even I use the administrator account. and I can access in IE the http://myserver/reports and http://myserver/reportserver , does anyone know if this url is asked when connect to report server from report builder?

I am thinking the report builder is not used this way? I mean it can only be accessed from report manager web site?

Connecting to MS SQL Server database using webmatrix.



I am novice  user to raizor syntax using webmatrix and i am trying to connect MS Sql server database (instead of using .sdf file i am using .mdf file) using the tool webmatrix for startersite.

The connection string that i setup as follows.

<?xml version="1.0"?>


        <compilation debug="false" targetFramework="4.0" />
    <add name="OESConnectionString" connectionString="Data Source=.\SQLServer2005;AttachDbFilename=|DataDirectory|\OES_Data.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />


And i am using websecurity helper as well and the setup is as follows.

WebSecurity.InitializeDatabaseConnection("Data Source=INLTE5556\\SQLServer2005;Initial Catalog=OES;Integrated Security=True", "System.Data.SqlClient", "UserProfile", "UserId", "Email", true);

When i am trying to insert the user details into database i am getting the below error.

Format of t

A connection could not be made to the report server http://localhost/ReportServer.



  • I created a Report using Business Intelligence Studio. Its working working well, i can able to view records. But when i try to deploy the report an error occurs specifying that "A connection could not be made to the report server http://localhost/ReportServer. (Microsoft Report Designer)".
  • I open the IIS 7 and find out virtual directories "Reports" and "ReportServer" are available.
  • I check on the browser and type "http://localhost/reports".  I find the browser direct to this url: http://localhost/reports/Pages/Folder.aspx and find error specifying the following one:

         Error:The report server is not responding. Verify that the report server is running and can be accessed from this computer.

  • when i type http://localhost/reportmanager, i found the error:

    HTTP Error 404.0 - Not Found

    The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.


SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services


Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

Virus Hunting: Track and Report Server Attacks Quickly and Easily with the .NET Networking Classes


To help stop the spread of worms, viruses, and other hostile activity, it is important to track down and report the servers used in these attacks along with those used to send spam. Many Web administrators, however, don't take the time to track them because the manual process can be quite cumbersome. The Microsoft .NET Framework comes to the rescue with several networking classes, including the Dns class and the TcpClient class, that abstract away the complexity of performing DNS and WHOIS lookups. These classes make it easy to create a simple, straightforward ASP.NET-based utility for performing these lookups and automating this very important task.

G. Andrew Duthie

MSDN Magazine April 2002

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend