Connection problems SQL Server

[borg2002]

Hi all,

I am having problems connecting to a database residing on a SQL Server2000 machine. However, when creating dimensions I can browse the data. It goes wrong when trying to process a cube. The error I am getting is :
Data source provider error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.;42000; Time:12/09/2002 9:00:41 AM

Does anyone knows how to solve this?

Thanks in advance
Borg

 

[hudi]

Hi,

check if your account is in OLAP Administrators group!

bye,
Andrej

 

[borg2002]

Thanks Andrej,

I'll give it a try...

Cheers
Borg

 

[borg2002]

I'm having Analysis Services installed on my PC and want to use a database on a SQL Server. I have read and write access. I manage to create a connection and even create a dimension. But when I want to process a dimension, I get the error "Data source provider error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Any ideas?

Thanks in advance
Borg

 

[sparky2708]

Try this - it helped me:

http://support.microsoft.com/default.aspx?scid=KB;en-us;q224973

 

[SD128]

I am not able to browse data.. The moment I click on browse data it gives an error "Unable to browse the cube "sales" unspecified error. I get connected to the server and connection is not a problem.

Any ideas?
Thanks in advance
Dave