Have Ananlysis Services on one server and want to use a seperate server for
http access. The IIS box is running WSS (do not know if it matters). I get
the following error message:
"LoadLibrary("C:\Inetpub\wwwroot\msmdpump.dll" ) failed - the specified
module could not be found"

I have copied the msmdpump.dll from the analysis server to the wwwroot on
the http server.

Hi,

Welcome to use MSDN Managed Newsgroup.

Since Enterprise Edition of Analysis Services SP3 allows you to use HTTP
connections to query AS and have AS on a different box than IIS. You
receive error message "LoadLibrary("C:\Inetpub\wwwroot\msmdpump.dll" )
failed - the specified
module could not be found" If I have misunderstood your concern, please
feel free to point it out.

Based on my knowledge, here is a general steps for how to do this and you
may ignore step 5 and 6 if the servers are in the same domain.

1. Make sure Analysis Server SP3 is installed on the server machine. Also
the clients connecting will have to have SP3 client upgraded by running
PTSLITE.EXE. PTSLITE.EXE is located in the SP3 MSOLAP/Install/PTS
directory.

2. Copy from the Bin folder of the Analysis Services that has SP3 installed
these two files, onto the IIS Server in the DMZ
MSMDPUMP.DLL
MSOLAP.ASP
The MSMDPUMP.DLL can go anywhere on the server, the MSOLAP.ASP will go into
your Web directory that your client will be putting in the connection
string to connect to AS.

3. Register the MSMDPUMP.DLL on the IIS machine by using REGSVR32.EXE from
the command line.

4. Modify the MSOLAP.ASP to include the server name of the Analysis Server.
See the following code.
Function ReadData
' ****** You can modify code of this function, but we don't recommend doing
it.
' ******
if (isEmpty(Session("StoredPump"))) Then
Set pump = Server.CreateObject("PUPump.PUPump.1")
Set Session("StoredPump") = pump
else
Set pump = Session("StoredPump")
End if
' This value can be changed.
pump.servername="AS Servername" ?- ***********************
pump.Timeout=60
pump.ReadData
Response.Flush
Response.End
End Function

5. You must open the ports 135,137,138,139 on the inner firewall so the
client can communicate to the Analysis Server.

6. If you are using Basic authentication with IIS you must either create a
local account with password on the IIS server and the exact same account
and password on the AS machine. Or you can follow the diagram below and
setup a one way trust between a domain in the DMZ and the domain that the
AS server is on. This would prevent the need of creating and maintaining
the matching accounts. And the clients would use DomainB\Username to
connect to AS.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.