Cannot Connect to the Analysis Server  
Author Message
JcJohn





PostPosted: Tue Jan 06 10:12:38 CST 2004 Top

SQL Server Developer >> Cannot Connect to the Analysis Server

I'm trying to retrieve a list of cubes from AS Server using Microsoft DSO in an ASP.NET page
Here's my sample code

Dim dsoServer As New DSO.Serve
Dim dsoDB As DSO.MDStor
Dim dsoCube As DSO.MDStor

dsoServer.Connect ("LocalHost"

For Each dsoDB In dsoServer.MDStore
If dsoDB.Name = "XXX" The
For Each dsoCube In dsoDB.MDStore
Debug.Print dsoCube.Nam
Nex
End I
Nex

Here's the message i got
"System.Runtime.InteropServices.COMException: Cannot
connect to the Analysis server on computer 'J.B.'.
Connection to the server is lost

I've tried to follow this technical article but still result the same
http://www.hide-link.com/

Any idea? Or is there any other way i can get what i want, other that connecting to DSO? I've been stuck with this problem for days. hope i can find a new way to solve this
Thnx in advanced

J.B

SQL Server209  
 
 
bmal1





PostPosted: Tue Jan 06 10:12:38 CST 2004 Top

SQL Server Developer >> Cannot Connect to the Analysis Server I was just working on something similiar. Here are a few things you
may want to check.

1) Make sure anonymous authentication on your virtual directory in IIS
is off.
2) make sure your windows login is part of the olap_administrators
group.
3) and as it is stated in the KB articly you referenced below that you
add the <Identity impersonate ="true"/> to the web.config

turning off anonymous authentication on the virtual directory solved
the probliem in my situation.

Hope this helps

bmal



> I'm trying to retrieve a list of cubes from AS Server using Microsoft DSO in an ASP.NET page.
> Here's my sample code:
>
> Dim dsoServer As New DSO.Server
> Dim dsoDB As DSO.MDStore
> Dim dsoCube As DSO.MDStore
>
> dsoServer.Connect ("LocalHost")
>
> For Each dsoDB In dsoServer.MDStores
> If dsoDB.Name = "XXX" Then
> For Each dsoCube In dsoDB.MDStores
> Debug.Print dsoCube.Name
> Next
> End If
> Next
>
> Here's the message i got:
> "System.Runtime.InteropServices.COMException: Cannot
> connect to the Analysis server on computer 'J.B.'.
> Connection to the server is lost"
>
> I've tried to follow this technical article but still result the same.
> http://support.microsoft.com/default.aspx?kbid=823066
>
> Any idea? Or is there any other way i can get what i want, other that connecting to DSO? I've been stuck with this problem for days. hope i can find a new way to solve this.
> Thnx in advanced.
>
> J.B.