Cannot create a connection to data source 'Mydatasource'. The feature: "The edition of Reporting Services that you are using requires that you use local SQL Server relational databases for report data sources and the report server database" is not supported in this edition of Reporting Services.
This error pops up when I am trying to view my report in Report Manager. I can, however, see the report in the Business Intelligence Studio. How can I view my report in Report Manager?
I've heard you can create a linked server on a SQL Server Express instance and have it point at a remote server. (I have not personally verified this as a workaround yet).You can then, supposedly, run reports against remote servers by connecting to the local SQL Server Express instance and referring the remote server using a four-part name.
Dig Deeper on Microsoft SQL Server Reporting Services (SSRS)
Related Q&A from Roman Rehak
There are a few things you can do to tune SQL Server for improved reporting performance. Here are some generic and Reporting Services-specific ... Continue Reading
Learn about working with image files in SQL Server, including advice on using queries to locate them, in this expert answer. Continue Reading
Is a license needed for a standby server if it's used for SQL Server replication? Get that answer and a comparison of SQL Server log shipping to ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.