Workaround to Reporting Services error in SQL Server Express

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?

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SQL Server Business Intelligence (BI) and Data Warehousing DBA career paths could lead to business intelligence Are data warehouses made for the cloud? Q&A: Business intelligence gets a facelift in SQL Server 2008 R2 Project Gemini gets a new name, Madison earns buzz Speed up reports in SQL Server Reporting Services with caching Data Transformation Services vs. SSIS: The key differences Using package configurations in SQL Server Integration Services (SSIS) How SQL Server 2008 components impact SharePoint implementations Achieving high availability and disaster recovery with SharePoint databases Recommended practices for SQL Server Analysis Services aggregations Archive: Reporting Services Tips for tuning SQL Server 2005 to improve reporting performance Manipulate column names in a SQL Server table Licensing a standby server for SQL Server replication SQL Server trigger vs. stored procedure to receive data notification Storing and searching for image files in SQL Server Can I encrypt and restore a database backup in SQL Server 2005? 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?

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

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.