Home > Archive > MS SQL Server OLAP > August 2005 > HIII ALL PLEASE HELP ME AS SOON AS PIS.









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 HIII ALL PLEASE HELP ME AS SOON AS PIS.
dr_7ef

2005-08-27, 11:23 am

1) i do all steps and takeing output file from excal after create
pivot table and conect it by OLAP Analysis Manager and change
connection string to http: connection like that

Provider=msolap.2;Initial Catalog=FoodMart 2000; Data
Source=http:// PORTALS;initialcatal
og; Client Cache Size=0;Auto Synch
Period=100000;Execut
ion Location=3;Large Level Threshold=100; Connect
Timeout=120;

2) than add this file to IIS with MSOLAP.ASP
3) ITS WORK FROM MY PC IF I GO TO ANY ONTHER PC IT NOT RUN AND GIVE ME
THIS ERROR
"Failed to get data. If available, errors returned from the provider
are listed below."

4) BUT I HAVE comment very important comment if onther pc use same
user and passord in workgroup not domin it run . but onther pc have
defrant username and passord give me this error
"Failed to get data. If available, errors returned from the provider
are listed below."

please help me why this error uper ............ please as soon as
pisoble :(

Jéjé

2005-08-27, 11:23 am

what s the authentication used in IIS ?
NTLM, or Basic? (try Basic authentication first)

have you disabled the anonymous access?
does your AS server is on the same server has IIS?

does the second PC can access the server? open iternet explorer and type:
http://<server>/msolap.asp

verify that you have the latest drivers installed on the PC. (execute the
ptslite.exe file to install the drivers)


"dr_7ef" <dr_7ef@hotmail-dot-com.no-spam.invalid> wrote in message
news:2MCdnUzp65HKEo3
eRVn_vA@giganews.com...
> 1) i do all steps and takeing output file from excal after create
> pivot table and conect it by OLAP Analysis Manager and change
> connection string to http: connection like that
>
> Provider=msolap.2;Initial Catalog=FoodMart 2000; Data
> Source=http:// PORTALS;initialcatal
og; Client Cache Size=0;Auto Synch
> Period=100000;Execut
ion Location=3;Large Level Threshold=100; Connect
> Timeout=120;
>
> 2) than add this file to IIS with MSOLAP.ASP
> 3) ITS WORK FROM MY PC IF I GO TO ANY ONTHER PC IT NOT RUN AND GIVE ME
> THIS ERROR
> "Failed to get data. If available, errors returned from the provider
> are listed below."
>
> 4) BUT I HAVE comment very important comment if onther pc use same
> user and passord in workgroup not domin it run . but onther pc have
> defrant username and passord give me this error
> "Failed to get data. If available, errors returned from the provider
> are listed below."
>
> please help me why this error uper ............ please as soon as
> pisoble :(
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com