Ssrs 2005 & ss2008 r2

Hello,

Can a SSRS 2005 server report use SQL 2008 R2 as a datasource? It certainly does with SQL 2008 so whats the difference?

Thanks
Chris

 

Thanks for getting back to me. That is what I thought except when I change the datasource from sql2008 to sql2008R2 I get:

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) "

This is with copying and pasting (many times to check) the datasource and login info (obv manually typing the password) from the relevant sections in my control panel. Am I being a bit thick or do I need to ticket this?

 

Hi,
You appear to have hit three versions of SQL with this...correct?
Only R2 is failing? If so can you be more specific about what you changed?
I'd like to try and re-create these steps for you.
All the best,
Mark

 

Hi Mark,

The only thing I had changed was the datasource for the report. First going into report manager and changing the datasource through the web interface and when that didn't work, changing the datasource locally and then uploading the report to DASP in case the report manager changes were not being committed.

I have also tried using a shared datasource with the R2 credentials and also putting the connection and credentials into the actual report.

Let me know if you need any more info.

Chris.

 

...Yeah I think Bruce is right on with that.
I've been asking around and there are no known issues.

 

...I did too.
R2 is what I'm using on this end.

 

...Just found something on Microsoft Technet that may have been related to this.

I think you have to be logged in to view this so I'll paste the article after the link:

http://social.technet.microsoft.com...-services-adventureworks-sample-reports.aspx/

Troubleshooting SQL Server 2008 R2 Reporting Services AdventureWorks Sample Reports
The SQL Server 2008 R2 Reporting Services AdventureWorks sample reports do not run and you receive the message “Cannot create a connection to data source AdventureWorks2008R2”.

To view the AdventureWorks sample reports for SQL Server 2008 R2 Reporting Services, you must have the corresponding AdventureWorks sample database installed. If you cannot connect to the AdventureWorks2008R2 database, you will not be able to run the corresponding sample reports.

The problem is most likely that the AdventureWorks2008R2 database is not installed.

Installation of AdventureWorks 2008 R2 RTM Sample Databases

The download package, AdventureWorks2008R2_RTM.exe, available on CodePlex (Sample Databases for Microsoft SQL Server 2008R2 (RTM)), includes three versions of the Adventure Works databases:

· AdventureWorksLT2008R2 (the light weight version with a simpler schema)

· AdventureWorksDW2008R2 (the data warehouse version)

· AdventureWorks2008R2 (the online transaction processing (OLTP) version that the AdventureWorks sample reports use)

To successfully install the AdventureWorks2008R2 OLTP sample database from AdventureWorks2008R2_RTM.exe, available at Sample Databases for Microsoft SQL Server 2008R2 (RTM), you must have an instance of SQL Server 2008 R2 that meets the following requirements:

· Full-Text Search is installed

· SQL Full-text Filter Daemon Launcher is running

· FILESTREAM is enabled

For step-by-step instructions to install and configure Full-Text search and FILESTREAM, see Database Prerequisites for SQL Server 2008R2 .

Note: To verify that all database versions installed, open SQL Server Management Studio and see which databases are in the Databases folder.



View Reports Successfully

Reports are designed to work with AdventureWorks2008R2. Updating the data sources of will not solve the problem. These databases have different schemas (for example, tables and columns have different names) and the report queries do not work with them. You must install AdventureWorks2008R2 to run the reports.

To solve the problem, you must install Full-Text search and configure FILESTREAM on the instance of SQL Server Database Engine that you are using, remove or rename any versions of 2008R2 versions of the Adventure Works databases, and then rerun AdventureWorks2008R2_RTM.exe from Sample Databases for Microsoft SQL Server 2008R2 (RTM).

Your Reporting Services Reports Displays Different or No Data

The date/time data in the AdventureWorks2008R2 database has changed from earlier versions of the database. Four years were added to date/time column values. If your reports, use parameters or filters set by date/time values, the data that displays in the reports might be different or the report might be blank.

To resolve the problem, update the filters or parameters or use the earlier SQL Server 2008 version of the database.

Showcase Localized Data in Reports

Additional localized product descriptions have been added to the AdventureWorksDW2008R2 database. The data is in the FactAdditionalInternationalProductDescription table. The addition of this table does not affect reports that use the AdventureWorksDW2008R2 database. They continue to run without modification.

 

...Forgot to mention that, good tip. ;-)