Analysis Services 2000 Tutorial

Has anyone tried the Quick Start tutorial?
I went through each of the steps and when I went to browse the data in the
Sales cube, I got the following error message:
Unable to browse the cube 'Sales'.
Unspecified error.
Has anyone else had this problem?
TIA
Try to apply service pack for Analysis Services. That works for me.
"Nimi" wrote:

> Has anyone tried the Quick Start tutorial?
> I went through each of the steps and when I went to browse the data in the
> Sales cube, I got the following error message:
> Unable to browse the cube 'Sales'.
> Unspecified error.
> Has anyone else had this problem?
> TIA

Analysis Services 2000 Tutorial

Has anyone tried the Quick Start tutorial?
I went through each of the steps and when I went to browse the data in the
Sales cube, I got the following error message:
Unable to browse the cube 'Sales'.
Unspecified error.
Has anyone else had this problem?
TIATry to apply service pack for Analysis Services. That works for me.
"Nimi" wrote:
> Has anyone tried the Quick Start tutorial?
> I went through each of the steps and when I went to browse the data in the
> Sales cube, I got the following error message:
> Unable to browse the cube 'Sales'.
> Unspecified error.
> Has anyone else had this problem?
> TIA

Analysis Services 2000 Tutorial

Has anyone tried the Quick Start tutorial?
I went through each of the steps and when I went to browse the data in the
Sales cube, I got the following error message:
Unable to browse the cube 'Sales'.
Unspecified error.
Has anyone else had this problem?
TIATry to apply service pack for Analysis Services. That works for me.
"Nimi" wrote:

> Has anyone tried the Quick Start tutorial?
> I went through each of the steps and when I went to browse the data in the
> Sales cube, I got the following error message:
> Unable to browse the cube 'Sales'.
> Unspecified error.
> Has anyone else had this problem?
> TIAsql

analysis service

Hi

I was doing steps on page 15 / 16 of attached sheet

I was doing the microsoft example about cube to setup DSN SOURCE CONNECTION to ACCESS database (food mart) when i do a test it works

but after i do design storage and go to Process the cube
it gives me error

'test connection failed because of an error in initializing provide
(microsoft) ODBC DRIVER manager data source name not found and no default driver specified

one more error found
Microsoft ODBC DRIVER MANAGER driver sql connect attr failed: IMOO6

ThanksOriginally posted by sjumma
Hi

I was doing steps on page 15 / 16 of attached sheet

I was doing the microsoft example about cube to setup DSN SOURCE CONNECTION to ACCESS database (food mart) when i do a test it works

but after i do design storage and go to Process the cube
it gives me error

'test connection failed because of an error in initializing provide
(microsoft) ODBC DRIVER manager data source name not found and no default driver specified

one more error found
Microsoft ODBC DRIVER MANAGER driver sql connect attr failed: IMOO6

Thanks

Ensure you have applied SP3. I'm pretty sure there is an MDAC upgrade.|||Hi

I have already upgraded with the patch but still does not work

Alternative to Account Delegation?

Hello,
I want to run distributed queries via a linked server using a windows
autheniticated login. Talking with our AD/network admin about the steps in
http://msdn.microsoft.com/library/d...>
ity_2gmm.asp
they have a problem with setting up account delegation for service account
and sql server computer, mainly because this is a new precedent and they
don't want to go there unless absolutely necessary.
Are there any alternatives to doing the above that would enable distributed
queries using windows authenicated logins?
Thanks,
DanHi
No. The way the OS has to impersonate and delegate security across machine
boundaries requires this. If there was an easier way, we would all be using
it.
Your admins will need to get used to it. As security gets tightened inside
the OS, you will need to use it more and more.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dan H" wrote:

> Hello,
> I want to run distributed queries via a linked server using a windows
> autheniticated login. Talking with our AD/network admin about the steps i
n
> http://msdn.microsoft.com/library/d...
urity_2gmm.asp
> they have a problem with setting up account delegation for service account
> and sql server computer, mainly because this is a new precedent and they
> don't want to go there unless absolutely necessary.
> Are there any alternatives to doing the above that would enable distribute
d
> queries using windows authenicated logins?
> Thanks,
> Dan