Re: How to enable Analysis Services with IIS on Win 2K

Thank you Dave,

"For the outside" means outside of my LAN or through the Internet.

The OLAP cube that I am trying to make available to the Internet users is
inside the Firewall - in my case small Linksys Cable/DSN router, port 80 is
open only and it is pointing to the Web server. There are two servers in this
scenario. The first one has IIS 5.0 (most recent SP applied, but I can't
chack which one now) and SQL 2K Analysis Server Enterprise Edition with SP3a
(let's call this one MY_IIS). The second server is database server with SQL
2K Standard Edition and SP3a (and let's call that one MY_SQL). It is also PDC.

In meanwhile I found "How to Connect to Analysis Services over the Internet"
webcast and tried to implement it. Here is what has been done so far:
- Msolap.asp copied to wwwroot directory on MY_IIS
- Msmdpump.dll is correctly registered on MY_IIS server
- Confirmed that Msolap.asp is installed correctly by typing
HTTP://MY_IIS/Msolap.asp in address bar - no error message, just plain blank
pag (as it should be)
- Allow Anonimus access on MY_IIS, default account is used
(IUSR_<MachineName>)
- Installed PivotTable Services, version 8.0 on the client machine
- Changed the connection string to have data source=HTTP://MY_IIS

At this point I have different results:
- If I use a server name (data source=HTTP://MY_IIS) all works fine
internaly (inside the firewall, on the LAN) and I still have "Unable to
connect to the Analysis server. The server 'MY_IIS' was not found" on a
client machine, connected through the Internet, located outside the firewall.
- If I use full URLin the connection string (data
source=HTTP://www.mydomain.com) the client machoine will eventually time out,
but most likelly IE is frozen and I should shut it down. The internal client
machine can't open it either.

I also tried to reduce a cube size to the bare minimum (fact table with
about 100 records and only 2 dimension tables with 5 records each). but it
still times out.

I hope that I covered everything relevant now.

Thank you, regards, Marin


"Dave Wickert [MSFT]" wrote:

> Can you explain your architecture a bit more?
> When you say "for the outside" what do you mean? Please include information
> on how many machines, what is running on those machines, what the doman
> infrastrure looks like and if there are any firewalls in the picture (if so
> where and what is blocked?).
> --
> Dave Wickert [MSFT]
> dwickert@xxxxxxxxxxxxxxxxxxxx
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "Marin" <Marin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:694386F8-4B41-43FC-8D05-6402BE650D96@xxxxxxxxxxxxxxxx
> > Hi all,
> >
> > I have OLAP cube created on SQL Analysis Server 2000 (SP3a). My web server
> > is on different machine, running IIS 5.0 running on Windows 2000 (SP2).
> >
> > When I deploy OLAP cube on IIS all works just fine on local network - all
> > uses can manipulate qube data in web browser (IE 6.0, FireFox...)
> > connecting
> > to default web site. However, from the outside I got "Unable to connect to
> > the Analysis server. The server 'ABC' was not found".
> >
> > PLEASE HEEEELP, I am hitting a deadline and IT IS DRIVING ME CREAZY!
> >
> > Thank you in advance, Marin
>
>
>
.

Relevant Pages

  • Re: Urgent! New router and big disaster
    ... The SBS DNS server, running on ... its IP it means that your problem is now DNS. ... forward ports to it reliably in the router. ... I should have been more clear about internet connection.. ...
    (microsoft.public.windows.server.sbs)
  • Re: RWW Disconnecting
    ... I have been connected from a remote site for about 3 ... DHCP server and even a wireless access ... the key codes to for Internet access. ... Client Workstations} ...
    (microsoft.public.windows.server.sbs)
  • Re: Urgent! New router and big disaster
    ... I checked the binding order and the Server Local area connection is at the top. ... I should have been more clear about internet connection.. ... I wonder if I may have missed a firewall setting on the router as well. ...
    (microsoft.public.windows.server.sbs)
  • RE: remote access SBS 2003 Inop
    ... Since you know the problem is relate to RRAS (Routing and Remote Access ... On the SBS 2003 Server open the Server Management console. ... Click the "Connect to the Internet" link. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: unable to access portfolio analyzer via internet
    ... You need to have the enterprise version of SQL Server 2000 to support access ... to the OLAP cube via the internet. ... > allow access to the portfolio analyzer through the internet. ... > get through to web access, but cannot view portfolio analyzer at all. ...
    (microsoft.public.project.pro_and_server)
Loading