Report Builder 3.0

sql-server-2008 ssrs-2008 reportbuilder
DavidStein picture DavidStein · Mar 5, 2010 · Viewed 10.9k times · Source

I'm using SQL Server 2008 (non-R2) and trying to use Report Builder 3.0. When I try to connect to the report server, I get an error:

Connection Failed. Unable to connect to the server that is specified in the URL......

However, I am using the same connection as my Report Builder 2.0 and that works fine.

Can RB 3 not work with pre- 2008 R2 databases?

Answer

Thiago Silva picture Thiago Silva · Mar 6, 2010

you're specifying two different issues:

first you said the error in your post is due to trying to connect to a Report Server catalog, not a DB for datasource of a report.

but you're asking if RB 3.0 can work with versions of SQL Server prior to 2008 R2.

The answer to the latter is yes, it can. RB 3.0 connects to a variety of data providers including SQL Server 2000, 2005, and 2008 (via the SQL Native Client), as well as Oracle, ODBC, OleDB, ADOMD (Analysis Services), Teradata, SAP BI, Essbase, XML, etc...

The former seems to be URL connectivity to the Report Server for a 2008 server. I know for a fact that if you use BIDS 2008 R2, instead of RB3, the deployment options for the report project provides a property "TargetServerVersion" to allow you to choose the version of the target server (2008 or R2, but not earlier). If you try to deploy an R2 report to a 2008 server using BIDS and the report has new features, BIDS will complain since it cannot "down-convert".

However, I am not sure that RB 3.0 can actually connect to a report server earlier than R2, like BIDS can. That would explain why you're getting connectivity issues.

HTH

Thiago

Related questions

SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: …

Read More
Reporting Services permissions on SQL Server R2 SSRS

I'm getting the error below when I try and access SSRS on SQL Server 2008 R2 I'm not sure how many others have started using SQL 2008 R2 SSRS, but I am having an issue with getting the error below when I …

Read More
Using the IN operator to filter in reporting services

Can anyone advise what the syntax should be when using the IN operator within a table filter. I have tried the below but the snytax is wrong:

Read More