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: 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: Tracking down Power View Performance Problems

    The scenario was that we saw sluggishness on the initial load of a Power View Report and also when we went to use one of the filters on the report - like a Pie Chart Slice. For the given report the customer had showed us, the initial load was taking 13-15 seconds to come up, versus 3-5 seconds on my...
  • 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: SharePoint Adventures : When connectivity is not connectivity

    I’m always amazed that issues usually come in batches.  I was looped into a few cases that had the following symptoms.   They were running SharePoint 2010 and Reporting Services 2012 SP1.  When they went to use a data source with Windows Authentication, they were seeing the following...
  • Blog Post: Using PowerShell to discover Reporting Services 2012 in SharePoint

    I was recently going through an exercise of documenting how to discover certain aspects of Reporting Services for some Kerberos work.  RS 2012 in SharePoint is a totally different game though.  The easiest way I could discover certain items about Reporting Services within SharePoint was with...
  • 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: SharePoint Adventures : Reporting Services, Claims and One Way Trusts

    I had an interesting case that was presented to me by our friends in the SharePoint support team.  The issue was that when they go to use a Data Source for Reporting Services that is set to use Windows Authentication, they saw the following: Within the SharePoint ULS logs we see the following: Throwing...
  • Blog Post: PowerPivot : When versions get mixed up…

    I worked a case today where they were trying to get SQL 2012 Reporting Services installed in a SharePoint environment that also had SQL 2008 R2 PowerPivot installed.  This, by itself, is fine and wasn’t really causing the problem.  When they tried to open the Excel Workbook from SharePoint...
  • 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 : 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: RS Content Types and SharePoint 2010

    When creating a new document library within SharePoint you have a few options.  You can just create a new Document Library, or you can go to More Options and choose Report Library.     When you choose Report Library, by default, it will allow you to create a report, but still will not...
  • Blog Post: Reporting Services and the MS09-062 GDR (GDI+)

    Updated 10/29/09:  Added section describing SQL Engine only servers at the bottom.   Brian Hartman did a great job outlining what the GDR is and why we had it.  You can read it here .  I’m not going to rehash that here.  What I wanted to do is outline some of the scenarios involving...
  • Blog Post: "Error: SharePoint is installed but not configured" when installing the RS Add-in on Windows 2008

    I ran across an interesting issue when trying to install the Reporting Services Add-in for SharePoint on a Windows 2008 server.  We would get the error listed above when trying to install the Add-in.  We choose repair on the Add-in component.  It got to the point of removing backup files...
Page 1 of 1 (18 items)