dbTalk Databases Forums  

Configuring http access to AS2005 std edition cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Configuring http access to AS2005 std edition cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Anatoli
 
Posts: n/a

Default Configuring http access to AS2005 std edition cube - 05-23-2006 , 09:24 PM






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/pro.../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,

Reply With Quote
  #2  
Old   
Edward Melomed [MSFT]
 
Posts: n/a

Default Re: Configuring http access to AS2005 std edition cube - 05-25-2006 , 10:09 PM






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" <Anatoli (AT) discussions (DOT) microsoft.com> wrote

Quote:
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/pro.../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,



Reply With Quote
  #3  
Old   
=?Utf-8?B?QW5hdG9saQ==?=
 
Posts: n/a

Default Re: Configuring http access to AS2005 std edition cube - 05-30-2006 , 12:30 AM



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?

"Edward Melomed [MSFT]" wrote:

Quote:
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" <Anatoli (AT) discussions (DOT) microsoft.com> wrote in message
news:7C0A1586-DE59-48DD-9036-4388E3CDC763 (AT) microsoft (DOT) com...
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/pro.../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,




Reply With Quote
  #4  
Old   
Dante
 
Posts: n/a

Default Re: Configuring http access to AS2005 std edition cube - 06-08-2006 , 10:27 PM



Hi Edward,
I have followed through article at
http://www.microsoft.com/technet/pro.../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]" wrote:

Quote:
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.
--


Reply With Quote
  #5  
Old   
Edward Melomed [MSFT]
 
Posts: n/a

Default Re: Configuring http access to AS2005 std edition cube - 06-09-2006 , 01:43 PM



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" <Dante (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi Edward,
I have followed through article at
http://www.microsoft.com/technet/pro.../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]" wrote:

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.
--




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.