22 Aug 2013
By Allen
0 Comments
How to configure Reporting Services 2012 for SharePoint 2013 integrated mode

How to configure Reporting Services 2012 for SharePoint 2013 integrated mode

SharePoint, SSRS, , ,
These are my installation notes because I did not find a clear tutorial for configuring SQL Server Reporting Services 2012 on a SharePoint 2013 server in Integrated Mode.  I found lots of SharePoint 2010 articles, but SharePoint has changed and now Reporting Services is actual a Service Application within the SharePoint farm. This post is aimed at setting up a single server development environment.  It assumes you have already installed the following: SharePoint 2013 SQL Server 2012 SP1 (Enterprise or Developer) SQL Server 2012 Reporting Services for SharePoint 1. Install the SSRS Service in SharePoint.  This is best done through…
Read More
30 Apr 2013
By Allen
0 Comments
How to fix “Usage Based Optimizer” connection errors in SSAS 2012

How to fix “Usage Based Optimizer” connection errors in SSAS 2012

SSAS, , ,
The Usage-Based Optimizer can be a very powerful tool for calculating aggregations, when it works. When it doesn't work perfectly, then it can be frustrating to figure out. The devil is in the details. If you move data between environment, then you have even more details to find and fix. Just for a quick overview, in Visual Studio for 2012 (BIDS for previous versions) your project properties deployment will point at an SSAS Server Instance which in turn has to have query logging configured to point to a SQL Server database.  That database table, then logs info about the queries…
Read More