Re: Excel 2007 connection

The Feature pack also contains the SQL Server Client (Native Client)
tools. You should install it.

RE
BT



Akshai Mirchandani [MS] skrev:
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

  • Re: olap for client
    ... Did you installed service pack 2 for SQL Server? ... Excel 2007 is required sp2 to use some feature. ... additional drivers for Excel 2007, I dont know what I'm doing wrong - he gets the sql server address, username and password and then reports no server, and on that server I regularly browse my cube within visual studio ... make sure you have installed the OLAP drivers ...
    (microsoft.public.sqlserver.olap)
  • Re: query a SQL server
    ... You just need a SQL Client Access Licence and a copy of the SQL Server ODBC ... In Excel go to Data / Import External Data / New Database Query and create a ... Run the client install from the SQL ...
    (microsoft.public.sqlserver.programming)
  • From excel connect to SQl
    ... I try from excel to connect a SQL server ... Can't i use this in excel or is it because i shall install some Tools/Ref ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • MSDE 2000 SP4 install gets to very end then rolls it all back
    ... On most machines my msde install goes fine. ... exuisting SQL server. ... Starting custom action SaveSqlServerServiceStates() ... Action start 14:23:53: RegisterClassInfo. ...
    (microsoft.public.sqlserver.setup)
  • Re: Critical Alert Update - W32.Slammer
    ... The .net SDK 1.0 sp1 comes with a very basic SQL Server engine for testing ... >> Microsoft SQL Desktop ... >>>cumulative SQL security patch, is completely safe from ... >> may install SQL ...
    (microsoft.public.security)