Q

Workaround to Reporting Services error in SQL Server Express

by
Roman Rehak

Discover a SQL Server workaround to fix an error that pops up when trying to view a report in the Report Manager when using Reporting Services in SQL Server Express.

I have received the following error during report processing:

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?

It sounds like you are using SQL Server Express. This edition of SQL Server does not support remote data sources, only local sources. Check out the MSDN article " Reporting Services in SQL Server 2005 Express Edition with Advanced Services" for more details.

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.

This was first published in February 2008

Dig Deeper on Microsoft SQL Server Reporting Services (SSRS)

PRO+

Content

Find more PRO+ content and other member only offers, here.

Related Q&A; from Roman Rehak, Contributor

Tips for tuning SQL Server 2005 to improve reporting performance

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

Manipulate column names in a SQL Server table

Learn SQL Server commands to manipulate column names in a table and turn column names into variables or rename SQL columns.continue reading

Storing and searching for image files in SQL Server

Learn about working with image files in SQL Server, including advice on using queries to locate them, in this expert answer.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.

You will be able to add details on the next page.

Meet all of our SQL Server experts

View all SQL Server questions and answers

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close