<div>
yes, it is. &nbsp;I found something strange though. &nbsp;I created a new embedded data source for the data sets and one of the reports now works. &nbsp;Previously, they were all using a shared data source with the exact same connection info. Maybe migrating the reports did something to the original data source.<br />
<br />
BTW - I didn't write these reports, I'm migrating them from a 2005 instance to a 2008R2 instance.
</div>


yes, it is.  I found something strange though.  I created a new embedded data source for the data sets and one of the reports now works.  Previously, they were all using a shared data source with the exact same connection info. Maybe migrating the reports did something to the original data source.

BTW - I didn't write these reports, I'm migrating them from a 2005 instance to a 2008R2 instance.

<div>
<div class="content wysiwyg-content">
I've got a bunch of reports that work fine when I preview them in Visual Studio. &nbsp;The account I'm using in the datasource is db_owner, datareader and datawriter and when i test the datasource connection, it tests fine. &nbsp;However, after publishing the report and running in IE, I get the following error. &nbsp;The proc exists and works fine, but it seems like it's not connecting to the DB when run through a browser.<br />
<br />
An error has occurred during report processing. (rsProcessingAborted)<br />
Query execution failed for dataset 'ReportDate'. (rsErrorExecutingCommand)<br />
Could not find stored procedure 'dbo.procName'.<br />
<br />
SQL Server 2008 R2 SP2<br />
IE 9
</div>
</div>


I've got a bunch of reports that work fine when I preview them in Visual Studio.  The account I'm using in the datasource is db_owner, datareader and datawriter and when i test the datasource connection, it tests fine.  However, after publishing the report and running in IE, I get the following error.  The proc exists and works fine, but it seems like it's not connecting to the DB when run through a browser.

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'ReportDate'. (rsErrorExecutingCommand)
Could not find stored procedure 'dbo.procName'.

SQL Server 2008 R2 SP2
IE 9

RS Error when Running Through Browser

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.