<div>
The problem had something to do with the vendors installation program for their reports. Just for kicks I re-deployed all their reports and now the reports work.
</div>


<div>
Thanks for checking in on this one.
</div>


<div>
<div class="content wysiwyg-content">
We have a window embedded in our application that displays SSRS reports. This has worked for years. Suddenly users reported that these reports were failing. They would all fail with a message similar to the one below. So I logged in as the domain admin who is also a sysadmin in SQL and I get the same message.<br />
<br />
Query execution failed for dataset 'seeGLAPDaysOutstandingDet<wbr />ail'. (rsErrorExecutingCommand) Get Online Help<br />
The EXECUTE permission was denied on the object 'seeGLAPDaysOutstandingDet<wbr />ail', database 'POWMT', schema 'dbo'. <br />
<br />
I know what this message means but why is the sysadmin getting this message? How can I track this down to find out what is really causing this?
</div>
</div>


We have a window embedded in our application that displays SSRS reports. This has worked for years. Suddenly users reported that these reports were failing. They would all fail with a message similar to the one below. So I logged in as the domain admin who is also a sysadmin in SQL and I get the same message.

Query execution failed for dataset 'seeGLAPDaysOutstandingDetail'. (rsErrorExecutingCommand) Get Online Help
The EXECUTE permission was denied on the object 'seeGLAPDaysOutstandingDetail', database 'POWMT', schema 'dbo'. 

I know what this message means but why is the sysadmin getting this message? How can I track this down to find out what is really causing this?

The problem had something to do with the vendors installation program for their reports. Just for kicks I re-deployed all their reports and now the reports work.

SSRS reports embedded in application suddenly stop working.

We have a window embedded in our application that displays SSRS reports. This has worked for years. Suddenly users reported that these reports were failing. They would all fail with a message similar to the one below. So I logged in as the domain admin who is also a sysadmin in SQL and I get the same message.

Query execution failed for dataset &#39;seeGLAPDaysOutstandingDetail&#39;. (rsErrorExecutingCommand) Get Online Help
The EXECUTE permission was denied on the object &#39;seeGLAPDaysOutstandingDetail&#39;, database &#39;POWMT&#39;, schema &#39;dbo&#39;. 

I know what this message means but why is the sysadmin getting this message? How can I track this down to find out what is really causing this?

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.