Configuring http access to AS2005 std edition cube

4310 views
Skip to first unread message

Anatoli

unread,
May 23, 2006, 10:24:02 PM5/23/06
to
Hi,

I've used the below URL to follow directions no configuring http access to
my AS2005 std edition cube.

http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx

However I seem to be running into a problem in that I am not being allowed
access. I've taken a look at my applications log which shows an informational
message stating:

Event Type: Information

Event Source: MSOLAP ISAPI Extension:
\\?\C:\Inetpub\wwwroot\Olap\msmdpump.dll

Event Category: (269)

Event ID: 10

Date: 5/24/2006

Time: 6:02:55 AM

User: N/A

Computer: "Server Name"

Description:

The description for Event ID ( 10 ) in Source ( MSOLAP ISAPI Extension:
\\?\C:\Inetpub\wwwroot\Olap\msmdpump.dll ) cannot be found. The local
computer may not have the necessary registry information or message DLL files
to display messages from a remote computer. You may be able to use the
/AUXSOURCE= flag to retrieve this description; see Help and Support for
details. The following information is part of the event: .
------------------------------

Do I need to register the msmdpump.dll or ??

If anyone has an idea, I'd appreciate some help.

regards,

Edward Melomed [MSFT]

unread,
May 25, 2006, 11:09:04 PM5/25/06
to
Please make sure all the paths are pointing to the same folders.
I think paper has few typos in few places it refers to a path as
C:\wwroot\olap\ and other as C:\inetpub\wwwroot\olap and so on ..
My bad .. have to get fixed.

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

"Anatoli" <Ana...@discussions.microsoft.com> wrote in message
news:7C0A1586-DE59-48DD...@microsoft.com...

Anatoli

unread,
May 30, 2006, 1:30:02 AM5/30/06
to
Edward,

it ended up being 2 things.

1. I didn't use the localhost option for the server when configuring
msmdpump.ini.
<ConfigurationSettings>
<ServerName>localhost</ServerName>
<SessionTimeout>3600</SessionTimeout>
<ConnectionPoolSize>100</ConnectionPoolSize>
</ConfigurationSettings>
2. I wasn't using the Microsoft OLE DB Provider for AS 9.0 provider.

once I change back to localhost and use the AS 9.0 provider as opposed to
the default for the connection, it worked just fine.

thanks,

P.S. Any possibility to answer my other question about connecting to the cube?

Dante

unread,
Jun 8, 2006, 11:27:01 PM6/8/06
to
Hi Edward,
I have followed through article at
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx , but
with a slight different architecture, Analysis server 2005 SP1 and IIS server
are on separate machine.
I try to configure msmdpump.ini (at IIS server) to point to my Analysis
Server (behind firewall, port 2383 opened), however, connection through owc
is failed, with error messages said "An error was encountered in transport
layer".
Do you have any idea to fix it? Any response will be appreciated, thanks.

Edward Melomed [MSFT]

unread,
Jun 9, 2006, 2:43:27 PM6/9/06
to
Try troubleshooting each connection leg separately.
First make sure you can connent using TCP/IP from IIS machine to your AS
machine.
Try to review credentials are used by IIS to impersonate the Pump.

You can find more information on troubleshooting TCP/IP connectivity on
http://www.sqljunkies.com/WebLog/edwardm/

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


"Dante" <Da...@discussions.microsoft.com> wrote in message
news:6B233F73-1454-45EA...@microsoft.com...

Reply all
Reply to author
Forward
0 new messages