Re: OleDbException... Connection to the server is lost.

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:
> 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 :-(

.