Browse by Tags

CSS SQL Server Engineers

This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services
  • Blog Post: Power View in Excel won’t render from SharePoint

    I originally encountered this issue back in May with a customer.  We had another customer this month that had the same issue.  When you try to load an Excel Document with a Power View Report in it from SharePoint, you may encounter the default unable to load power view report image. Before...
  • Blog Post: SharePoint Adventures : Using Claims with Reporting Services

    Back in February of 2011, I created a blog that walked through using Kerberos with Reporting Services . Since then, we have moved Reporting Services to a shared service within SharePoint.  This changes the game and we are now in the Claims world.  I’ve been asked a bunch of times regarding...
  • Blog Post: RS, SharePoint and Forefront UAG Series – Intro

    I have been working a fairly complicated case over the last year that involved running Reporting Services Reports through a Universal Access Gateway (UAG) to publish a SharePoint Site.  I worked with an engineer (Alejandro Lopez) in the SharePoint Support Group as well as two folks (Prateek Gaur...
  • Blog Post: RS, SharePoint and Forefront UAG Series – Part 2 (Operational Reports)

    Part 1 – Intro Part 2 – Operational Reports (Classic RDL Reports) (you are here) Part 3 – Power Pivot Gallery (Silverlight) Part 4 – Export a Power View Report to PowerPoint   This piece took the longest amount of time to narrow down what was going on.  This issue was when they were trying...
  • Blog Post: RS, SharePoint and Forefront UAG Series – Part 3 (Power Pivot Gallery - Silverlight)

    Part 1 – Intro Part 2 – Operational Reports (Classic RDL Reports) Part 3 – Power Pivot Gallery (Silverlight) (you are here) Part 4 – Export a Power View Report to PowerPoint   The last post really went into the meat of the issue that we had.  After that, we found that when trying to go to the...
  • Blog Post: RS, SharePoint and Forefront UAG Series – Part 4 (Power View - Export to PowerPoint)

    Part 1 – Intro Part 2 – Operational Reports (Classic RDL Reports) Part 3 – Power Pivot Gallery (Silverlight) Part 4 – Export a Power View Report to PowerPoint (you are here) The last part of this engagement was when they tried to Export a Power View report to PowerPoint, we hit the save button, and received...
  • Blog Post: Invalid or loopback address when configuring SharePoint against a SQL Server

    I was presented with a connectivity issue when trying to configure SharePoint 2013 using a CTP build of SQL 2014.  They got the following error when they were it was trying to create the Configuration Database. Exception: System.ArgumentException: myserver,50000 is an invalid or loopback address...
  • Blog Post: Power View display issues with Page Viewer Web Part

    I ran into two separate issues this week that both dealt with displaying a Power View report through a Page Viewer Web Part within a SharePoint page in SharePoint 2013. The resolution to both were the same, so I thought I would lump them both into this post. Issue 1: Visual Artifacts while scrolling...
  • Blog Post: Getting a SharePoint List Data Source to work with Reporting Services Native Mode

    A case came up where the user was trying to use Report Builder in a Reporting Services instance that was not integrated with SharePoint.  It was in Native Mode configuration.  They indicated that they were getting a 401 error.  My initial thought was that we were hitting a Kerberos issue...
  • Blog Post: SharePoint Adventures : Claims, Named Pipes and Kerberos

    I ran into a new Kerberos Scenario that I hadn’t hit before when I was working on the cases related to this blog post . It’s rare that I actually see a case related to the Named Pipes protocol.  When I do, it is usually a customer trying to get it setup with a Cluster deployment.  I have never...
  • Blog Post: Getting a Power View report within Excel 2013 to work with SharePoint

    I was setting up my SharePoint 2013 server to be able to use an Excel 2013 workbook that had a Power View Report in it.  However, when I tried opening the workbook, I got the following error: In the ULS logs of my SharePoint server that had RS installed on it, I saw the following: Microsoft.ReportingServices...
  • Blog Post: FileNotFoundException with Microsoft.AnalysisServices.Xmla

    I ran across two cases that were hitting the following Exception within SharePoint trying to run the PowerPivot Management Portal.  This was located in the SharePoint ULS Log: EXCEPTION: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices.Xmla, Version=11...
  • Blog Post: AdomdConnectionException using PerformancePoint hitting Analysis Services

    I was working with a customer who was encountering problems trying to use a PerformancePoint Dashboard against an Analysis Services Instance. The issue came down to the Claims to Windows Token Service (C2WTS) configuration.  This is used to take the Claims context and convert it to a Windows Token...
  • Blog Post: SharePoint Adventures : AccessDeniedException when a user tries to Add Subscription

    I’ve been seeing a few cases that relate to a previous blog post which involved an AccessDeniedException when trying to perform report operations.  However, I ran into a different variation that involved the same error.  The scenario was that the customer has users that were in a the Viewer...
  • Blog Post: SharePoint Adventures : Access Denied errors when using RS 2012 with a Claims SharePoint Site

    I actually ran into this issue back in late April.  I wanted to get this out sooner but life happened.  This issue has started to crop up a lot more as more people are starting to use Reporting Services 2012 in SharePoint Integrated mode.  Here is the run down.  This issue is specific...
  • Blog Post: SharePoint Adventures : “The connection either timed out or was lost” with RS DataSource to SSAS

    A customer had encountered an issue with their SharePoint 2010 / Reporting Services 2012 deployment.  They had setup a Data Source for Reporting Services that was setup to connect to a stand alone Analysis Services instance.  When they clicked on “Test Connection” they saw the following:  ...
  • Blog Post: Could not load file or assembly System.EnterpriseServices

    While setting up a SharePoint 2010 environment with Reporting Services 2012, I hit an interesting error. To explain my setup, this is a Classic Mode Auth site with Kerberos enabled for the site. I had verified that I had the proper accounts configured and Kerberos Configuration in place. Also, knowing...
  • Blog Post: SharePoint Adventures : Why isn't Claims working with SSRS?

    SharePoint 2010 introduced a new authentication architecture called Claims Based Authentication SharePoint Claims-Based Identity http://msdn.microsoft.com/en-us/library/ee535242.aspx When using Claims Based Authentication for your SharePoint site, in order for authentication to flow between services...
  • Blog Post: SharePoint Adventures : How to identify if you are using Claims Authentication

    When integrating Reporting Services with SharePoint, the authentication scheme for the SharePoint site can affect how Reporting Services works. I've been asked many time about how to tell if the SharePoint site is using Claims or is in Classic mode. Central Admin To determine if you are using Claims...
  • Blog Post: SharePoint Adventures : Using Kerberos with the Report Server

    Previous Post: SharePoint Adventures : Setting up Reporting Services with SharePoint Integration In the previous post, I walked through getting RS 2008 R2 Integrated with SharePoint 2010. What I didn't touch on was if you wanted to get this work with Kerberos. Kerberos itself can be complicated. This...
  • Blog Post: SharePoint Adventures : Setting up Reporting Services with SharePoint Integration

    I've had some questions in the past regarding Reporting Services Integration with SharePoint. For this post, I'm going to focus on SharePoint 2010. I'm also going to assume that you already have a SharePoint Farm setup. The examples I'm going to use will be a full SharePoint Cloud, but the steps will...
  • Blog Post: My Kerberos Checklist…

    I’ve had numerous questions regarding Kerberos, both internally within Microsoft and with Customers.  It continues to be a complicated topic and the documentation that is out there can be less than straight forward.  Based on some previous items I’ve worked on, I wanted to share my experience...
Page 1 of 1 (22 items)