Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

SSAS2008 and Kerberos

with 2 comments

Kerberos is notoriously difficult to set up – it’s something I’ve always left to someone else to do! Anyway, I’ve just come across a very detailed white paper from Boyan Penev and Mark Dasco about setting up Kerberos for Microsoft BI which I thought was worth linking to for future reference:
http://bp-msbi.blogspot.com/2009/04/enhanced-security-and-integration-of.html

However, I’ve heard from a number of sources (Dr John Tunnicliffe; Dan English) recently about problems with getting Kerberos to work with Windows 2008 Server or Vista, and this post from John Desch at MS confirms the bug – worse, it doesn’t seem to be fixed in SP1 (which got released this week):
http://blogs.msdn.com/psssql/archive/2009/04/03/errors-may-occur-after-configuring-analysis-services-to-use-kerberos-authentication-on-advanced-encryption-standard-aware-operating-systems.aspx

One to watch out for…

Written by Chris Webb

April 12, 2009 at 7:51 am

Posted in Analysis Services

2 Responses

Subscribe to comments with RSS.

  1. "worse, it doesn’t seem to be fixed in SP1"Unfortunately, it\’s a bug in Windows Kerberos so SQL 2008 SP1 can\’t do anything to help. The expectation is that there will be a Windows patch for it soon after SP2 of Windows 208 is released.The blog points to some workarounds in the meantime…Thanks,Akshai

    Akshai

    April 12, 2009 at 8:32 pm

  2. I have run into this bug with three separate accounts. It is a windows 2008 server bug that has not been resolved. In all cases, the only "solution" was to go back to Windows Server 2003. I\’m hoping that there will soon be a fix.

    David

    April 20, 2009 at 1:15 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,190 other followers

%d bloggers like this: