Last post Jun 19, 2012 01:09 AM by rpk2006
Jun 19, 2012 01:09 AM|rpk2006|LINK
I have two SQL Server instances installed:
2008 R2, and
2008 (with the name SqlServer2008).
Both instances have Reporting Services installed. The Report Server URLs for both the above are as below respectively:
I built a reporting project which was using 2008 R2 instance as DataSource. I was able to successfully deploy this project to the second (2008) Report Server.
Later I exported the entire 2008 R2 database to 2008 instance. After this when I try to deploy the Reporting project by changing the DataSource to 2008, it gives error:
Shared DataSource and Shared DataSet is not supported in Sql Server 2008.
I deleted the Shared DataSource and Shared DataSet from the Solution Explorer, and kept the DataSource and DataSet settings intact in the Report Data pane.
I am still not able to deploy.
How to deploy the project and what changes are needed in DataSource and DataSet?