Home > Ask the SQL Server Experts > Roman Rehak - SQL Server Development and Reporting Services Questions & Answers > Workaround to Reporting Services error in SQL Server Express
Ask The SQL Server Expert: Questions & Answers
EMAIL THIS

Workaround to Reporting Services error in SQL Server Express

Roman Rehak EXPERT RESPONSE FROM: Roman Rehak

Pose a Question
Other SQL Server Categories
Meet all SQL Server Experts
Become an Expert for this site


Expert advice on database administration
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 20 February 2008
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?


>
EXPERT RESPONSE
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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


RELATED CONTENT
SQL Server data warehousing/business intelligence
Parent-child dimensions in SQL Server 2005 with Analysis Services MDX
Troubleshoot Web service issues in SQL Server 2005 Reporting Services
Ordering the results of a SQL query
SSIS error message due to installation problem on SQL Server 2005
Configuring SQL Server with a changed computer name
Using MDX and UDM in a SQL Server Analysis Services environment
Change data capture in SQL Server 2008 improves BI reporting accuracy
Manage traces in SQL Server 2005 Analysis Services with XMLA commands
Tutorial: SQL Server 2005 Analysis Services
Top 10 SQL Server Integration Services (SSIS) and DTS tips

Roman Rehak - SQL Server Development and Reporting Services
Using BULK INSERT to insert rows from SQL Server dataset to table
SQL Server query to import database names
Troubleshoot SQL Server 2005 SP2 installation error
How can I export stored procedures in SQL Server 2005?
Code to restore SQL Server databases in VB.NET
Stored procedure for a BULK INSERT to SQL Server 2005 text file
BULK INSERT to import data from file to SQL Server database
INSTEAD OF trigger to update a SQL Server table
Retrieve images from SQL Server and store in VB.Net
Can you import Excel data to SQL Server Reporting Services?

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
data aggregation  (SearchSQLServer.com)
data preprocessing  (SearchSQLServer.com)
data warehouse  (SearchSQLServer.com)
FileMaker  (SearchSQLServer.com)
GIS  (SearchSQLServer.com)
MOLAP  (SearchSQLServer.com)
pivot table  (SearchSQLServer.com)
Quiz: SQL Server 2000  (SearchSQLServer.com)
SQL  (SearchSQLServer.com)
T-SQL  (SearchSQLServer.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy 		  TechTarget - The IT Media ROI Experts