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: 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...
  • Blog Post: Analysis Services - Errors when trying to add a User as a Server Admin

    When trying to add a user as a Server Admin to Analysis Services, you may encounter one of the following errors: The following system error occurred:  The trust relationship between the primary domain and the trusted domain failed. (Microsoft.AnalysisServices) Or The following system error occurred...
  • Blog Post: Microsoft CSS @ PASS Summit 2012

    This is a little later than we normally do it, but better late than never!  During November 6th-9th, the US PASS Summit 2012 will be held in Seattle, Washington at the Seattle Convention Center.  The Microsoft CSS team has a long history with PASS.  We have been speaking and working at...
  • Blog Post: Bulk Insert and Kerberos

    I recently worked on two Bulk Insert cases that dealt with Kerberos. My favorite past time! In both cases, the customers were hitting the following error: Msg 4861, Level 16, State 1, Line 1 Cannot bulk load because the file "<file name>" could not be opened. Operating system error code...
  • 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 : 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: SETSPN -A with Windows 2012 does a duplicate check upfront

    If you have followed my posts, or caught my sessions at PASS, you may have figured out that Kerberos is one of my strength areas.  I recently setup a Windows 2012 server to just see how SharePoint Integration with Reporting Services would work out.  As I was doing that, I knew I would need...
  • 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: 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...
Page 1 of 4 (78 items) 1234