All,

I have Win XP and using Analysis Services 2000 on it. I am stucked in a
strange problem. I can process cubes successfully. Also, I can fire
queries through MDX sample application successfully. But when I try to
fire the same query through my ASP.NET client, I get the the following
exception:

System.Data.OleDb.OleDbException
Message: Formula member name [Time].[Range] is not valid.
Connection to the server is lost
Source: Microsoft® OLE DB Provider for Analysis Services.

Same code when I run on a win 2000 machine, everything works fine.

I am using Anonymous Authentication method, giving the domain user name
and password. The same user is the member of the OLAP Administrators
group also.

Help is required urgently!

Thanks in advance!

Sheetal :-(

Have you tried setting process model identity to SYSTEM account? Find
the <processModel> tag in the machine.config file of the machine where
the ASP.Net application runs (IIS). Change the username value to
"SYSTEM" and password to "AutoGenerate". Save the file, restart
IIS and then see if it works.

Will this app be deployed on Win XP or Win 2003? If it would be
deployed on Win 2003 test this on Win 2003 and there you might need to
change the application pool properties so that the Identity is set to
LOCAL SYSTEM account.

Let me know if that doesn't work and we can see a few more things.

Thanks,

Sukesh.

sheetal wrote: