Effective Thoughts

If you're experiencing "Query execution failed for dataset 'ds[Whatever]'. ", more than likely, your warehouse processing is failing. Going into the Admin Console or invoking the web service directly , invoking the Start Rebuild action, I kept receiving a TF221122. Finally, when I added the account under "Account for accessing data sources" under the "Analysis Services" tab to the SQL Server Tfs_Warehouse database TFSEXECROLE role, processing began to succeed again. Whew.

Recently, I delivered a client presentation on SQL Server Reporting Services 2008. There were some follow-ups I thought I’d share: Q. After creating and deploying an .RDL file to Report Manager, later, when I want to modify it, can I bring it back into BIDS? A. Yes. Simply create a new, empty Reporting Services project within BIDS and then Add >> Existing, browse out and open the existing .RDL file. You may need to make some minor edits if you were using a shared data source. Q. Compare Report Builder 2.0 with BIDS. A. Reference this page: http://www.microsoft.com/sqlserver/2008/en/us/report-builder.aspx Q. Compare SSRS 2008 for Standard and Enterprise SQL Server editions. A. Reference this document: http://download.microsoft.com/download/2/D/F/2DF66C0C-FFF2-4F2E-B739-BF4581CEE533/SQLServer2008EnterpriseandStandardFeature%20Compare.pdf Additional, informative article: http://sqlserverpedia.com/wiki/SQL_Server_Standard_and_Enterprise Q. Is there a freely av...