hi!
i have a web app on one server which try to connect to another server with
AS. I would like to know why it doesn't work.

my server IIS has my app and the msolap.asp file, which has the
pump.ServerName line.
my AS server is on the same domain, with SQlServer2000 SP3.
if i try to use my app from a machine on the same domain, it can't see the
cubes; and if i try from a machine on another domain, there's a time out
response.

what's the problem?

--
Message posted via http://www.sqlmonster.com

have you setup the clear/text (basic) authentication for IIS server?

To make sure that the security delegation works fine, try first a clear text
authentication.
and also, make sure the user can see the cubes (define some roles in your
AS)

"allison via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

You might review this white paper:
http://msdn.microsoft.com/library/de...l_datapump.asp
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"allison via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

thanks for your answers!

to begin i have seen this
already:http://msdn.microsoft.com/library/de...l=/library/en-
us/dnsql2k/html/sql_datapump.asp
and i think i have ever done all that is said!

for the access, i use anonymous access. i'll try with basic authentication
and i'll see if it works beter!

thanks!

--
Message posted via http://www.sqlmonster.com

i tried the basic authentication and the responses are the same.

my cubes roles are for "everyone" isn't it enough?

thanks!

--
Message posted via http://www.sqlmonster.com

to see the connection, i've tried to changed the msolap file like this:

Function ReadData
' ****** You can modify code of this function, but we don't recommend doing
it. ***************
'DEBUGGING

Dim fsoObject 'File System Object
Dim filObject 'File Object
Dim txtFile

set fsoObject = Server.CreateObject("Scripting.FileSystemObject")
set filObject = fsoObject.GetFile("wayto\Msolap_log.txt")
set txtFile = filObject.OpenAsTextStream(8, 0)

txtFile.Write Cstr(now()) &" ready to pump,"

if (isEmpty(Session("StoredPump"))) Then

Set pump = Server.CreateObject("PUPump.PUPump.1")

txtFile.Write " created object PUPump.PUPump.1,"


Set Session("StoredPump") = pump
txtFile.Write " set session to pump, "
else
Set pump = Session("StoredPump")
txtFile.Write " set pump to session, " &Session("StoredPump")& " end
Session"
End if
' This value can be changed- I changed it here for security-it is not real
ip we use
pump.ServerName="ip_server"
pump.Timeout=60
txtFileObject.Write " !!!ready to read data!!! "
pump.ReadData
Response.Flush
Response.End
Set fsoObject = Nothing
Set filObject = Nothing
Set txtFile = Nothing

End Function


i don't understand why i never have my logfile create ... is there a
relationship with my problem?

--
Message posted via http://www.sqlmonster.com

no more idea?
please!!

--
Message posted via http://www.sqlmonster.com

I dont know why you have no file created, certainly due to permissions
errors.
and this could cause problems in the asp file, so you can't access your
cube.

Keep the original msolap.asp just with the target server changed.
make sure you use clear/text authentication and anonymous access is
disabled.
make sure you IIS log is enable, so you'll track any access to the
msolap.asp file (including response status like 200 for success 401 for
login errors...)
Access your cubes using Excel or the MDX Sample application


"allison via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

On the same domain (let's get that working first) you said it cannot see the
cubes. Is this all cubes? Can it see the cubes in Foodmart?

Second, what tool are you using to query the server (i.e. the one which says
that there are no cubes)? What does the MDXSampl app return?
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"allison via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote