Showing posts with label cubes. Show all posts
Showing posts with label cubes. Show all posts

Saturday, February 25, 2012

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.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 connec
ting to DSO? I've been stuck with this problem for days. hope i can find a n
ew way to solve this.
Thnx in advanced.
J.B.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
"J.B." <anonymous@.discussions.microsoft.com> wrote in message news:<7FAAB41D-1136-4308-AF9C-49AD40
722246@.microsoft.com>...
quote:

> 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 conn
ecting 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.
|||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
"J.B." <anonymous@.discussions.microsoft.com> wrote in message news:<7FAAB41D-1136-4308-AF9C-49AD40
722246@.microsoft.com>...[QUOTE]
> 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 dsoDB As DSO.MDStore
> Dim dsoCube As DSO.MDStore
> If dsoDB.Name = "XXX" Then
> For Each dsoCube In dsoDB.MDStores
> Debug.Print dsoCube.Name
> Next
> End If
> Next
> "System.Runtime.InteropServices.COMException: Cannot
> connect to the Analysis server on computer 'J.B.'.
> Connection to the server is lost"
> http://support.microsoft.com/default.aspx?kbid=823066
> Thnx in advanced.

Thursday, February 16, 2012

Cannot connect to SQL 2000 AS SP 3 cube from Excel 2000

I have a user who is using Excel 2000 SP 3 to connect to cubes created
in SQL 2000 AS SP 3. The user does have permissions to browse to the cube.
Originally I could not even connect to the cube itself, nor did I have the
OLAP 8.0 provider. I tried all the Office updates, and per a newsgropu tip,
I installed the pivot table service (SQL2000 CD
\msolap\install\PTS\ptslite.exe). I can connect to the cube from his
computer from Excel, but if I create a spreadsheet elsewhere using that
cube, his laptop will not open the cube to run queries. Any suggestions?
****************************************
*********
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
This posting is provided "as is" with
no warranties and confers no rights.
****************************************
*********Ask your database administrator to look at the record locking on the cube,
or use a read-only connection.
MH
"Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
news:uPe4c8bUGHA.5884@.TK2MSFTNGP14.phx.gbl...
> I have a user who is using Excel 2000 SP 3 to connect to cubes created
> in SQL 2000 AS SP 3. The user does have permissions to browse to the
> cube. Originally I could not even connect to the cube itself, nor did I
> have the OLAP 8.0 provider. I tried all the Office updates, and per a
> newsgropu tip, I installed the pivot table service (SQL2000 CD
> \msolap\install\PTS\ptslite.exe). I can connect to the cube from his
> computer from Excel, but if I create a spreadsheet elsewhere using that
> cube, his laptop will not open the cube to run queries. Any suggestions?
>
> --
> ****************************************
*********
> Andy S.
> MCSE NT/2000, MCDBA SQL 7/2000
> andymcdba1@.noreply.yahoo.com
> Please remove "noreply" before replying.
> This posting is provided "as is" with
> no warranties and confers no rights.
> ****************************************
*********
>

Cannot connect to SQL 2000 AS SP 3 cube from Excel 2000

I have a user who is using Excel 2000 SP 3 to connect to cubes created
in SQL 2000 AS SP 3. The user does have permissions to browse to the cube.
Originally I could not even connect to the cube itself, nor did I have the
OLAP 8.0 provider. I tried all the Office updates, and per a newsgropu tip,
I installed the pivot table service (SQL2000 CD
\msolap\install\PTS\ptslite.exe). I can connect to the cube from his
computer from Excel, but if I create a spreadsheet elsewhere using that
cube, his laptop will not open the cube to run queries. Any suggestions?
--
*************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
This posting is provided "as is" with
no warranties and confers no rights.
*************************************************Ask your database administrator to look at the record locking on the cube,
or use a read-only connection.
MH
"Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
news:uPe4c8bUGHA.5884@.TK2MSFTNGP14.phx.gbl...
> I have a user who is using Excel 2000 SP 3 to connect to cubes created
> in SQL 2000 AS SP 3. The user does have permissions to browse to the
> cube. Originally I could not even connect to the cube itself, nor did I
> have the OLAP 8.0 provider. I tried all the Office updates, and per a
> newsgropu tip, I installed the pivot table service (SQL2000 CD
> \msolap\install\PTS\ptslite.exe). I can connect to the cube from his
> computer from Excel, but if I create a spreadsheet elsewhere using that
> cube, his laptop will not open the cube to run queries. Any suggestions?
>
> --
> *************************************************
> Andy S.
> MCSE NT/2000, MCDBA SQL 7/2000
> andymcdba1@.noreply.yahoo.com
> Please remove "noreply" before replying.
> This posting is provided "as is" with
> no warranties and confers no rights.
> *************************************************
>

Cannot connect to SQL 2000 AS SP 3 cube from Excel 2000

I have a user who is using Excel 2000 SP 3 to connect to cubes created
in SQL 2000 AS SP 3. The user does have permissions to browse to the cube.
Originally I could not even connect to the cube itself, nor did I have the
OLAP 8.0 provider. I tried all the Office updates, and per a newsgropu tip,
I installed the pivot table service (SQL2000 CD
\msolap\install\PTS\ptslite.exe). I can connect to the cube from his
computer from Excel, but if I create a spreadsheet elsewhere using that
cube, his laptop will not open the cube to run queries. Any suggestions?

*************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
This posting is provided "as is" with
no warranties and confers no rights.
*************************************************
Ask your database administrator to look at the record locking on the cube,
or use a read-only connection.
MH
"Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
news:uPe4c8bUGHA.5884@.TK2MSFTNGP14.phx.gbl...
> I have a user who is using Excel 2000 SP 3 to connect to cubes created
> in SQL 2000 AS SP 3. The user does have permissions to browse to the
> cube. Originally I could not even connect to the cube itself, nor did I
> have the OLAP 8.0 provider. I tried all the Office updates, and per a
> newsgropu tip, I installed the pivot table service (SQL2000 CD
> \msolap\install\PTS\ptslite.exe). I can connect to the cube from his
> computer from Excel, but if I create a spreadsheet elsewhere using that
> cube, his laptop will not open the cube to run queries. Any suggestions?
>
> --
> *************************************************
> Andy S.
> MCSE NT/2000, MCDBA SQL 7/2000
> andymcdba1@.noreply.yahoo.com
> Please remove "noreply" before replying.
> This posting is provided "as is" with
> no warranties and confers no rights.
> *************************************************
>

Cannot connect to SQL 2000 AS SP 3 cube from Excel 2000

I have a user who is using Excel 2000 SP 3 to connect to cubes created
in SQL 2000 AS SP 3. The user does have permissions to browse to the cube.
Originally I could not even connect to the cube itself, nor did I have the
OLAP 8.0 provider. I tried all the Office updates, and per a newsgropu tip,
I installed the pivot table service (SQL2000 CD
\msolap\install\PTS\ptslite.exe). I can connect to the cube from his
computer from Excel, but if I create a spreadsheet elsewhere using that
cube, his laptop will not open the cube to run queries. Any suggestions?

*************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
This posting is provided "as is" with
no warranties and confers no rights.
*************************************************
Ask your database administrator to look at the record locking on the cube,
or use a read-only connection.
MH
"Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
news:uPe4c8bUGHA.5884@.TK2MSFTNGP14.phx.gbl...
> I have a user who is using Excel 2000 SP 3 to connect to cubes created
> in SQL 2000 AS SP 3. The user does have permissions to browse to the
> cube. Originally I could not even connect to the cube itself, nor did I
> have the OLAP 8.0 provider. I tried all the Office updates, and per a
> newsgropu tip, I installed the pivot table service (SQL2000 CD
> \msolap\install\PTS\ptslite.exe). I can connect to the cube from his
> computer from Excel, but if I create a spreadsheet elsewhere using that
> cube, his laptop will not open the cube to run queries. Any suggestions?
>
> --
> *************************************************
> Andy S.
> MCSE NT/2000, MCDBA SQL 7/2000
> andymcdba1@.noreply.yahoo.com
> Please remove "noreply" before replying.
> This posting is provided "as is" with
> no warranties and confers no rights.
> *************************************************
>