Excel 2007 connection

I wanted to evaluate the new features of Excel 2007 regarding cubes, so I
set up a test machine with it.

I do have SSAS 2005 SP1 running through IIS, and several users connect with
Excel 2003 - works nice. The IIS is set to use Windows Authentication only,
so my users have to enter a username and password of an account on the
server to get their data. The user accounts are enabled in SSAS with
different access settings. Works really fine!

With Excel 2007, I cannot connect anymore, I get an error 0x80040e4d. This
error is mentioned within groups as (DB_SEC_E_AUTH_FAILED) several times,
but no answer really fits to Excel 2007 and Olap - some are with Jet, ADO,
ODBC but nothing "recent" pointing to Excel 2007.

I am doing nothing different that I did for almost a year with Excel 2003,
in fact I just need to take one step to the next system and can connect with
Excel 2003 using the same account, server, http address and all. I did try a
couple of accounts, passwords and so on to make sure that is not my problem
or that typing of password was wrong.

As side note, if I set the IIS to allow anonymous access (and have IIS map
to a user the SSAS knows) I do get access with Excel 2007, so it is REALLY
the authentification that fails.

Any explanation?


.

Relevant Pages

  • Re: Excel 2007 connection
    ... I know I need to install the OLE-DB Analysis 9 driver, which in turn requires the MSXML 6 driver to make Excel 2003 work. ... I usually download these from Microsoft.com, I find them by typing "SQL Feature Pack April" in search window. ... The IIS is set to use Windows Authentication only, ... Excel 2003 using the same account, server, http address and all. ...
    (microsoft.public.sqlserver.olap)
  • Migrating from SSAS 2005 to SSAS 2008
    ... We currently use SQL Server Analysis Services (SSAS) 2005 to provide OLAP ... information to Excel 2003 users. ... ActiveWorkbook.PivotCaches.Item.Connection = myConnection ... VBA macro? ...
    (microsoft.public.sqlserver.olap)
  • Re: Excel 2007 connection
    ... [Excel 2007 will not connect to SSAS] ... I made a totally clean install of OS and Office 2007 and used MSXML, ... Can someone confirm he can connect from Excel 2007 to SSAS? ... The Feature pack also contains the SQL Server Client ...
    (microsoft.public.sqlserver.olap)
  • RE: Excel Services External Data error
    ... Excel Calculation Services. ... Note that I am getting the data from SSAS 2005 ... and still getting this same solid error on any Excel Service External Data ... Of course the excel 2007 spreadsheet works fine outside of MOSS 2007. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: SSAS 2005 drillthrough from excel 2003
    ... I do not know if you can make SSAS 2005 drillthrough to work in Excel 2003. ... Is there any setup do I need to do in excel in order to get the drill through? ...
    (microsoft.public.sqlserver.olap)
Loading