I’ve had about 4 cases in the last two months that centered around the following error when trying to use Windows Integrated authentication with JDBC. java.sql.SQLException: This driver is not configured for integrated authentication The key environment point on this was that they were trying to do this...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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: ...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...