|
Home > Archive > MS SQL Data Warehousing > March 2006 > Cannot connect to SQL 2000 AS SP 3 cube from Excel 2000
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cannot connect to SQL 2000 AS SP 3 cube from Excel 2000
|
|
| Andy S. 2006-03-27, 11:23 am |
| 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.
>
> ********************
********************
*********
>
>
|
|
|
|
|