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?
View questions and answers from all of our SQL Server experts here.
Dig Deeper on SQL Server Business Intelligence Strategies
Related Q&A from Eric Brown
SQL Server expert Eric Brown helps troubleshoots an issue encountered when exporting to Excel. Continue Reading
SQL Server expert Eric Brown provides some helpful resources on business intelligence and data mining in SQL Server 2005. Continue Reading
SQL Server expert Eric Brown explains the pros and cons of data warehousing. 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.