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

If you had a simple .htm file on http://www.mydomain.com/test.htm
Can you bring that up though the Intenet connection?
--
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:BA53F803-48A0-4528-AB76-8FE7C3BE2307@xxxxxxxxxxxxxxxx
> 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: Outgoing POP3 email missing/lost/not received
    ... ISP's mail server instead of the domain name on the ... SUMMARY OF SETTINGS FOR CONFIGURE E-MAIL AND INTERNET ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)
  • Re: Urgent! New router and big disaster
    ... Anyway the Server Ipconfig /all is this... ... Server Local Area Connection: ... Les Connor [SBS Community Member - SBS MVP] ... First Page of the Internet Connection Wizard, ...
    (microsoft.public.windows.server.sbs)
  • Re: VPN breaks after installing patches
    ... Now I understand that you are using the PPPoE connection and no router is ... a virtual network adapter will be ... 825763 How to configure Internet access in Windows Small Business Server ... Run the Change Server IP Address to change the internal IP address. ...
    (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: Non-domain connection problem
    ... Ethernet adapter Local Area Connection: ... Connection-specific DNS Suffix. ... I hard coded the DNS server to a known DNS on the internet: ... Again this had no effect on the ability to connect to the internet. ...
    (microsoft.public.windows.server.sbs)