Re: SSAS 2005 with Kerberos/Delegation

Does delegation work when you connect through OLEDB ? What are the exact
SPNs that you used ? What is the exact connection string ?

--
==============================­====================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL­og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================­====================
"Kevin Dente" <kevind@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eLOMCij6FHA.3760@xxxxxxxxxxxxxxxxxxxxxxx
> I've been trying (and failing) to get Kerberos delegation to an SSAS 2005
> server working. I've followed all of the steps on:
>
> http://www.mosha.com/msolap/articles/kerberos_delegation.htm
>
> But still no luck. Delegation is working fine with SQL Server, but not
> Analysis Services.
>
> I've verified the SPN, connection string, enabled delegation, configured
> with web site (typical IE to IIS to SSAS setup), etc, but no luck - the
> connection to the server always shows up in Profiler as "anonymous", and
> the connection fails.
>
> Are there any tools or tricks for debugging this problem? I'm at a loss at
> this point. If it matters, the code that fails to connect is doing AMO
> stuff (or trying to, anyway), not ADOMD.NET.
>
>
>
>
>
>
>


.

Relevant Pages

  • Re: How to enable Analysis Services with IIS on Win 2K
    ... > Can you bring that up though the Intenet connection? ... >> The OLAP cube that I am trying to make available to the Internet users is ... >> open only and it is pointing to the Web server. ... >> In meanwhile I found "How to Connect to Analysis Services over the ...
    (microsoft.public.sqlserver.olap)
  • Re: Scripting data mining
    ... SqlConnection only works with SQL Server. ... For Analysis Services you should use the generic OleDb classes in ADO.Net: ... A query analyzer-like tool for Analysis Services Data Mining is available as ... connection to the>> Analysis Services server. ...
    (microsoft.public.sqlserver.datamining)
  • Re: How to enable Analysis Services with IIS on Win 2K
    ... Can you bring that up though the Intenet connection? ... SQL BI Product Unit (Analysis Services) ... > "For the outside" means outside of my LAN or through the Internet. ... > open only and it is pointing to the Web server. ...
    (microsoft.public.sqlserver.olap)
  • RE: analysis services excel add-in and pivot tables connection issue
    ... Your password may be cached in the client machine. ... > I have analysis services on a server. ... > and Analysis services products on my machine. ... > If I go to cubeAnalysis Manage connection when I type in the server name, ...
    (microsoft.public.sqlserver.olap)
  • Re: Connection problem between an OLAP cube and Excel
    ... On the server side.I have already installed sp3 for Analysis services. ... Impossible to open the connection. ... you need to install it there by running the latest mdac version available from Microsoft's site ...
    (microsoft.public.sqlserver.olap)