SSAS 2K5 Dimension Processing

I have a lot of experience with SSAS 2K, but I am trying out SSAS 2K5 (June CTP) for the first time. I am trying to build cubes against a SS 2K database on a different computer on the network (Win 2003).

Everything works great until I try to process a dimension--where it always fails. I think I have tried every permutation of access security and impersonation. Messages are like, "The following system error occurred: The specified domain either does not exist or could not be contacted." Other messages occur when the authority setup is different.

Errors are the same when I try to develop a dimension against a local copy of Adventure Works DW.

What am I missing?

Larry

[684 byte] By [LarryFoat] at [2008-1-29]
# 1

One thought is to check and see what provider you are using for the data source. If it is the new SQL Native Client, try changing it to the OLE DB Provider for SQL Server.

When you say a "local copy of Adventure Works DW", is that local to the same machine that SSAS 2K5 is on? And is it local within SS2K or within SS2K5?

Dave Fackler

DaveFackler at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...

SQL Server

Site Classified