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: 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: 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: 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: 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: 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: SocketException when upgrading Reporting Services from SQL 2008/R2 to SQL 2012

    I ran into an interesting case yesterday that brought back some memories.  The customer had a SQL 2008 R2 instance of Reporting Services that they were upgrading to SQL 2012.  They didn’t get far into the upgrade when they hit the following error which was present in the Setup Logs: (16) 2012...
  • 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: BISM: value of the 'EffectiveUserName' XML for Analysis property is not valid

    I’ve been working with Power View reports and one of the items I was setting up was using a BISM Data source connecting to an Analysis Services Instance in Tabular Mode.  When I went to spin up a new Power View Report against the BISM Connection, I got the following error: Within the details, we...
  • Blog Post: Working with Power View: Some controls on this presentation can't be activated

    When one of our Managers opened up the PowerPoint slide deck that Power View generated, he got the following error: Some controls on this presentation can't be activated. They might not be registered on this computer. I had found some references to the RC0 timeline indicating that if you had PowerPoint...
  • Blog Post: Working with Power View: Click to Interact is not available

    I was working on a Power View report for our internal business numbers and we are making use of the Export to PowerPoint feature to include them in our slide deck.  If you aren’t familiar with this feature in Power View, when you are in the report, click on “file” and then “Export to PowerPoint...
  • Blog Post: The case of the incorrect page numbers

    As you may or may not know, SSRS 2008 R2 added the ability to automatically create page breaks on group changes.  Historically, people attempted to use custom code to accomplish this and, while it worked, the pagination logic we use in SSRS 2008 R2 breaks the standard implementation of this for...
  • Blog Post: Exporting via HTML instead of MHTML

    There was a question on Twitter about how to display a report in HTML instead of MHTML due to some browser issues.  Based on the fact that it was MHTML, I’m assuming we are talking about exporting a report as the default report view is HTML.  First off, if we look at our export options for...
  • Blog Post: Why the Query Designer Table Listing could be empty

    I just worked a case that took a little bit to figure out and involved some pretty deep debugging, but I figured I would get something out to explain the behavior to hopefully prevent someone else from having to go through the debugging that I just went through. To give some background, when designing...
  • Blog Post: MS11-028 may cause issues with SQL, Exchange and PowerShell

    A .NET Security Update (MS11-028) may end up causing issues with applications that make use of the .NET Framework, mostly resulting in applications being unable to launch, or loss of functionality within Native Applications that make use of .NET. In some cases, it could lead to an application crash....
  • Blog Post: RS Report Performance Relief in CU7

    Cumulative Update 7 for SQL 2008 R2 was just released.  Within that CU, there are two fixes for Reporting Services that people should be aware of that related to report performance. Large HTML This issue is related to reports that have a large amount of HTML elements.  This could be due to...
  • Blog Post: Why am I getting prompted for Credentials?

    I just wrapped up a case for an issue I see every once and a while.  The scenario is the following: Browse to site Get Prompted for credentials and enter username and password Web site will come up normally I’ve seen where some people go into Kerberos troubleshooting mode, but that in itself is...
  • Blog Post: Think Negative (with RS Visibility)

    I was helping Bob Dorr out with a report he was creating.  He was trying to get some images and a column to hide under certain conditions.  He added the expression based on data using the Iif() function.  His complaint was that the column and/or image was still showing and wasn’t hidden...
Page 1 of 3 (52 items) 123