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

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

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

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

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

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

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

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

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

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

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’m sitting in SEATAC Airport waiting for my flight, so I thought now would be a great time to write up some thoughts and share some experiences of my week at PASS. There was a ton of great information this year and we also announced Denali – the next version of SQL Server! From what I could...

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

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

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

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