Home > Ask the SQL Server Experts > Archive: Business Intelligence Questions & Answers > Visual Studio report processing error
Ask The SQL Server Expert: Questions & Answers
EMAIL THIS

Visual Studio report processing error

Eric Brown EXPERT RESPONSE FROM: Eric Brown

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


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


>
QUESTION POSED ON: 11 February 2006
I developed an RS report in Visual Studio 2003 that accesses an external database located in our Windows 2000 Server domain controller. In my Windows XP Desktop, the report works fine when I test it in the preview option of VStudio. I deployed the report to a Windows 2000 Member Server, which is the Report Server. When I try to run the report from my desktop through the Report Manager (Internet Explorer), I get the following error:

An error has occurred during report processing. (rsProcessingAborted) - Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) - Specified cast is not valid.

If I run the report locally in the Report Server it works fine. MSDN has an article about database connection problems but it does not solve the question. Could you help me please?


>
You need to check the report manager to make sure the data source for the report is present. It's definitely a data source issue.

View questions and answers from all of our SQL Server experts here.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious 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: Business Intelligence
Troubleshoot Web service issues in SQL Server 2005 Reporting Services
Ordering the results of a SQL query
Using MDX and UDM in a SQL Server Analysis Services environment
SSIS error message due to installation problem on SQL Server 2005
Configuring SQL Server with a changed computer name
Resources for business intelligence and data mining in SQL Server 2005
Problems exporting to Excel
The pros and cons of data warehousing
Problems running SQL Server 2000 RTM without service pack
Decreasing the size of a datafile

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



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

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




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