Skip to content

Posts from the ‘Business Intelligence’ Category


Delivering Tax Technology Solutions with SQL 2012

For those of you who don’t know for the past couple of years I’ve been focusing on creating our services around Tax Technology using the latest Microsoft technologies. Our fiscal year ends at the end of this month and thinking back I’m happy to say that last year was a very productive year. The Solution Center that I run was able to launch several services and solutions for the Tax world. Some of the solutions we rolled out to our clients are Tax Operations Manager, Tax Data Warehouse Service, Data Import and Set-Up Service, Corporate Tax Reporting (ITRS), Tax Community of Interest Site, Transfer Pricing Integration Manager (TPiM), Audit Manager, Tax Operations Manager for Live Events, and Tax Development Service which are all compatible with SQL Server 2012 and sit on SharePoint.

Even though SharePoint was the core foundation, SQL 2012 was a very critical part of all of these solutions. We’re leveraging all aspects of SQL 2012 from Integration Services to Analysis Services to Reporting Services. We’re leveraging Data Quality services and Master Data Services. Tabular BISMs are a core part of our architecture which allows us to quickly create new models for our Tax clients. BI with SQL 2012 is just pure fun to work with. My team was very happy with what we could accomplish very limited budget and time. As always after a long year of developing on SQL 2012 I’m putting together series of blogs, content and presentations.  I’m looking forward to getting back to the presenting world and connecting with all of you.

Having said that I’m super excited to let you know that my next session will be the  SharePoint Fest – D.C. 2013  August 5-7 – Bethesda North Marriott Conference Center Feel free to use the following code (Cavusoglu100DC) for a discount when you’re registering.  Below are the details for the session. Look forward to seeing you there.

BI 102 – Data in the Cloud: Creating SharePoint 2013 BI Solutions using Azure

In this session we will cover the different flavors of Azure and to Windows Azure SQL Services. We will look at creating reports using Data in the Cloud. We will connect to a Azure SQL Database through WCF Data Services. We will also cover the topic of Big Data. An overview of Big Data concepts and and how to use big data without crashing your budget and servers. And finally we will go over the Azure Data Market, we will look at the basic concepts around building an app to consume data from a Windows Azure Data Market feed.


SSRS 2012 Service Application in Sharepoint 2013 returns internal Server Error (500)

So you are installing SQL Reporting Services in a 2 or more server farm. And when you go to the service to manage it you’re getting the following error

Application error when access /_admin/ReportServer/ReportingServicesSystemSettings.aspx, Error=The remote server returned an error

If you’re getting this error after you installed the SQL Reporting Services Add-in for SP2013 that means you haven’t installed Reporting Services on a SharePoint 2013 server. You can either install SharePoint on your Reporting Services installed server or  install Reporting Services to one of your SharePoint App servers.

Install SQL Server 2012 Reporting Services on a SharePoint application server. In the SQL Server 2012 installation wizard, choose ‘Reporting Services – SharePoint’ on the feature selection page.

PowerView SQL 2012 and SharePoint 2013

Install Reporting Services SharePoint Mode for SharePoint 2013

So you installed SQL 2012 and SharePoint 2013 but you don’t know how to get Reporting Services working so you can use Power view? Well no worries here is a summary of what you need to do.

First, Install the Service

The first thing you need to make sure you do is install the service on SharePoint. Run the following PowerShell commands in SharePoint 2013 Management Shell as an administrator.

  1. Install-SPRSService
  2. Install-SPRSServiceProxy
  3. get-spserviceinstance -all |where {$_.TypeName -like “SQL Server Reporting*”} | Start-SPServiceInstance

Second, Create the Service Application

After you install the service in Central Administration you will now have the option to create a new SQL Server Reporting Services Service Application.  Go to  Application Management group, click Manage Service Applications and create a new service application. If you don’t see this option that means the above steps weren’t successful in creating the service. So make sure you have that completed before you try to create a new service application.

Third, Activate the Powerview Feature

To activate the feature, go to the site collection features and find the feature Power View Integration Feature  in the list and click Activate.



For detailed step by step how to visit the MSDN article – Install Reporting Services SharePoint Mode as a Single Server Farm