Can''t connect to Analysis Services Cube using Excel 2007

Hi, i made a cube using Analysis Services 2005, but when i try to connect to Analysis Services using Excel 2007, i got the following error: (excuse me but i had the spanish version of Microsoft Office 2007, y hope you understand):

"El asistente para conexión de datos no puede obtener una lista de las bases de datos del origen de datos especificado"

i got that error when i put the name of the server and the authentication. Previously i made a report on excel 2007 using other cube with exactly the same configuration of server an credentials, but i erase that cube and made a new one, i only change the structure of the cube, the credentials, even the names, are the same as the old one.

i don't know what happens or what i'm missing out this time.

i had sql server 2005 with sp2 installed.

i'm working on Windows Vista. i applied all the patches to make sql server 2005 and visual studio 2005 work perfect on vista. I GOT ALL THE PATCHES FOR VISTA.

i also started all the services for Sql Server 2005 (Analysis Services, etc etc.)

I hope you can help me.

Thanks.

Guillo.

I found the solution for my problem:

Because of the securities of windows vista, it's necesary to delegate the right permissions to the current user you are working with.

In my case, i delegate the permissions when i installed SQL Server 2005, but it seems that for some unknown reason they were erased. So, i open "Configuración de superficie de SQL Server" (sorry, i'm using sql server 2005 spanish), then i re-delegate the right permissions to my current user in windows, and i made the report on excel 2007 with my cube.

That easy.