Re: Excel 2007 connection

Can you try installing the SP2 CTP2 (Tech Preview) OLE-DB Analysis 9 driver instead? This strikes me as something that may have been fixed in SP2...

SP2 CTP2 is available from below:
http://www.microsoft.com/sql/ctp.mspx

There is a link to the feature pack from there...

One thing you may want to try is to use regsvr32.exe to re-register the DLL msolui90.dll -- usual warnings apply...

HTH,
Akshai

--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Ralf Mayer" <Ralf.Mayer1@xxxxxx> wrote in message news:#ML0QnVDHHA.4404@xxxxxxxxxxxxxxxxxxxxxxx
I am afraid I do not know what software you mean...

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. There is also a feature pack dated November 2005, I do not know if these are different from the April 2006 versions, I always use April versions anyway.

But I installed them, I am quite sure about that since I wanted to test without first, just to see if they are part of Office 2007 now. Without them did not work, so I installed them both as I do for Excel 2003. After adding them, it still did not work though...

Is that what you mean? Or are these SQL 2005 some special additions to Office 2007 already?

"Bjørn T" schrieb...
Have you installed the following:

1) SQL Server 2005 OLAP driver (SP1)
2) SQL Server 2005 Client compoment (SP1)

You should have installed both. Works real nice on my machine.

BT




Ralf Mayer skrev:
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

  • Excel 2007 connection
    ... I wanted to evaluate the new features of Excel 2007 regarding cubes, ... I do have SSAS 2005 SP1 running through IIS, ... The IIS is set to use Windows Authentication only, ... Excel 2003 using the same account, server, http address and all. ...
    (microsoft.public.sqlserver.olap)
  • Re: Excel Services error and Kerberos
    ... the same account towards SSAS will be used whatever ... I got it work with SSO! ... (SharedServices running Excel Services) ... In the group "Security Configuration" click at the link "Manage settings ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Accounting Reports in Access
    ... this was an Excel sheet. ... This is linked to the main information table using the account number ... you could build a report that groups by teach organization. ... I would then build a sub report that sums up all of the payments made by ...
    (microsoft.public.access.reports)
  • RE: Slow file access
    ... This issue does appear to be isolate to the one account. ... Other Excel and other file types seem to be okay. ... The problem occurs no matter which PC this user logs onto. ... > Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Retrieve User Attributes (DisplayName & Description)
    ... some User Account attributes, if the User Account does in fact exist (E.g. ... Dim strTo, strRaceNo, strName, strSurname, strEMailAddress, strTPT_From, ... ' Open the Spreadsheet ... ' Bind to Excel object. ...
    (microsoft.public.scripting.vbscript)
Loading