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: Getting Cross Domain Kerberos and Delegation working with SSIS Package

    I started working on this issue started by way of a Twitter conversation between myself, Jorge Segarra ( @sqlchicken ) and Matt Masson ( @mattmasson ). I then found out that Jorge was working with a customer that had opened up a Support Case.  Also special thanks to Joey Seifert for letting me bounce...
  • Blog Post: Kerberos Configuration Manager updated for Analysis Services and SQL 2014

    Kerberos Configuration Manager was released back in May of 2013.  It initially released with only SQL Server support . This was followed up with support for Reporting Services in November 2013. You can download the latest release from the following link: Microsoft® Kerberos Configuration Manager...
  • Blog Post: How to grab multiple parent/child elements from XML Data Source

    We had a question come up about why an XML query wasn’t pulling a 2nd Parent/Child element from the resulting data.  This was grabbing data off of a Web Service.  The example I was given was a public Web Service call for getting Weather information. http://wsf.cdyne.com/WeatherWS/Weather.asmx...
  • 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: Can’t Connect to SQL when provisioning a Project App in SharePoint

    The customers issue was that they were trying to provision a Project site within the Project SharePoint Application. This was done via a PowerShell script that they ran on one of the SharePoint App Servers. They had two SharePoint App Servers – AppServerA and AppServerB. They had indicated that the provisioning...
  • Blog Post: Kerberos Configuration Manager updated for Reporting Services

    Back in may, we released the Kerberos Configuration Manager tool to help with diagnosing and correcting Kerberos related issues for SQL Server.  Today, I’m happy to announce that version 2 of this tool has been released and has been updated for Reporting Services.  A lot of work went into this...
  • Blog Post: SQL Connection Pool Timeout Debugging

    This is a follow up to two blog posts from back in 2009 which talked about leaked connections.  In Part 1 and Part 2 of that post, it was about how to determine that you actually filled your pool.  This was centered around the following error: Exception type: System.InvalidOperationException...
  • Blog Post: Microsoft CSS @ PASS Summit 2013

    During October 15th-18th, the US PASS Summit 2013 will be held in Charlotte, NC at the Charlotte Convention Center.  The Microsoft CSS team has a long history with PASS.  We have been speaking and working at PASS since 2003.  This year we will have the added advantage of being on our home...
  • 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: Error trying to access SharePoint List from Power Query

    When trying to pull data from a SharePoint List Data Source, using the Microsoft Online Services ID, you may see the following output in your query: DataFormat.Error: OData: The given URL neither points to an OData Service or a feed: ‘https://login.microsoftonline.com/login.srf?wa=wsignin1.0&rpsnv...
  • 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: 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: 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: RS: Database Engine does not meet edition requirements

    I've ran across the following error a few times and thought I would post this out there for people to understand what is happening. ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: , Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException...
  • Blog Post: Breaking Down 18056

    We have had two blog posts on this blog regarding the 18056 error.  Two from Bob Dorr (and part 2 ) and another from Tejas Shah .  However, we still see a lot of questions about this error message. This error message can show up for different reasons.  After those two blog posts were made...
  • 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...
Page 1 of 4 (87 items) 1234