Groups | Blog | Home
all groups > sql server connect > january 2004 >

sql server connect : Cannot Connect to the Analysis Server



J.B.
1/5/2004 6:01:05 PM
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://support.microsoft.com/default.aspx?kbid=82306

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
bmal1 NO[at]SPAM msn.com
1/6/2004 8:12:38 AM
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


[quoted text, click to view]
J.B.
1/6/2004 10:21:10 PM
Thanks for your advice.
It works now.

~~
J.B.

----- bmal wrote: -----

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


[quoted text, click to view]
AddThis Social Bookmark Button