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: Don’t Rely On a Static IP Address for Your SQL Database

    I’ve seen a number of customers open support incidents because they couldn’t connect to their SQL Database server which was ultimately due to the incorrect assumption that the server’s IP address is static. In fact, the IP address of your logical server is not static and is subject to change at any time...
  • 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: 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: 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: When Does sp_prepare Return Metadata

    I was running an RML Utilities Suite test pass and encountered varying behavior from our sp_prepare suite.  Here is what I uncovered. The command sp_prepare returns (or does not return) metadata depending on the server version.  For the client version, it is only significant whether it is prior...
  • 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: 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: 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 : “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: To 1433 or not to 1433...that is the question

    I recently ran into a problem with one of my own internal applications and it re-raised a philosophical question I have had before with customers.  There are really two sides to the question: 1) Should I set my non-default instance to listen on TCP 1433? 2) Should I set my default instance to listen...
  • 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: How It Works: Error 18056 - The client was unable to reuse a session - Part 2

    I have had several questions on my blog post: http://blogs.msdn.com/b/psssql/archive/2010/08/03/how-it-works-error-18056-the-client-was-unable-to-reuse-a-session-with-spid-which-had-been-reset-for-connection-pooling.aspx related to SQL Server 2008's honoring of an query cancel (attention) during the...
  • Blog Post: How It Works: Error 18056 - The client was unable to reuse a session with SPID ##, which had been reset for connection pooling

    This message has come across my desk a couple of times in the last week and when that happens I like to produce blog content. The error is when you are trying to use a pooled connection and the reset of the connection state encounters an error. Additional details are often logged in the SQL Server error...
  • 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...
  • Blog Post: Error 18056 can be unwanted noise in certain scenarios

    I saw a lot of hits on the web when I searched for the Error message 18056 with State 29. I even saw two Microsoft Connect items for this issue filed for SQL Server 2008 instances: http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=468478 http://connect.microsoft.com/SQLServer...
  • Blog Post: What SPN do I use and how does it get there?

    This month has turned into another Kerberos Month for me.  I had an email discussion regarding SPN’s for SQL Server and what we can do to get them created and in a usable state.  I thought I would share my response to the questions as it will probably be helpful for someone.  Here was...
  • Blog Post: How to get a x64 version of Jet?

    We have had a number of people ask about how they can get the Jet ODBC driver/OLE DB Provider as 64 bit.  Windows only ships the 32 bit versions of these.  The answer is that the windows versions won’t be x64 as those items are deprecated.  What does deprecated mean?  Here is the...
  • Blog Post: ‘Cannot Generate SSPI Context’ and Service Account Passwords

    Was working with Keith Elmore on one of our internal processes and he was hitting a “Cannot generate SSPI context” when trying to connect from Management Studio.  I also saw this come up in a double hop situation (IIS to SQL) when I setup a local repro. We went through the normal check list for...
  • Blog Post: SQL 2008 - New Functionality to the dm_os_ring_buffers for Connectivity Troubleshooting

    Hi, I wanted to make everybody aware of this feature in SQL 2008. Are you tired of having to use NetMon to narrow down a connectivity issue with SQL Server 2008 or have to wait for an elusive connectivity error to reoccur? A new ring buffer called "RING_BUFFER_CONNECTIVITY' has been...
  • Blog Post: Report Builder and Firewalls

    We have had a few customer calls come in on this scenario that I thought this needed to be documented a bit. Scenario: In this scenario, the customer has a data source defined on the Report Server.  Some were using Named Instances, others were using a Default Instance for the Data Source. There...
  • Blog Post: When in doubt, Reboot!

    I tend to get quite a bit of Kerberos related cases.  These are related across the box, from the Engine, to Reporting Services to just straight connectivity with custom applications.  I had one given to me yesterday because the engineer had gone through everything we normally go through and...
  • Blog Post: Searching for Duplicate SPN's got a little easier

    We get a lot of calls related to Kerberos configuration, and I'm planning to write more about our experiences and troubleshooting techniques for these types of issues across the box (Engine, AS and RS). With Windows 2000/2003 SetSPN had only a few commands associated with it. Switches: -R = reset...
  • Blog Post: How to troubleshoot leaked SqlConnection Objects (.NET 2.0) - Part 2

    In the last post in this series, we looked at how we can determine that our Connection pool was exhausted. In this post I'm going to go a little deeper into the Internal connection itself and how we can verify if this is a closed or active connection. Dumping out the internal connection objects ...
Page 1 of 2 (32 items) 12