Re: Remote server config

Hi,

First of all SQL 2000 on Server 1 should be Enterprise edition !

Install ReportPortal 2.0 on server 2.0 and have it working with your
server 1 or any other internet server with MS Analysis Services 2000.
Than try to have your server 3 working in the DMZ. It could be a
setting in the DMZ.

If you have any questions, please contact us: www.gmsbv.nl we are
specialised in in OLAP for Internet with use of Panorama NovaView or
ReprotPortal based on Microsoft Analysis Services.

Regards, Marco


"Akshai Mirchandani [MS]" <akshaim@xxxxxxxxxxxxxxxxxxxx> wrote in message news:<eF5g1T5PFHA.3076@xxxxxxxxxxxxxxxxxxxx>...
> The class factory error usually means you are missing some COM component --
> but you would need to identify whether it is XMLA or Snowflake that is
> raising the error...
>
> Try using the XMLA SDK sample applications on Server 2 to see if the XMLA
> SDK appears to be working...
>
> Thanks,
> Akshai
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> Please do not send email directly to this alias. This alias is for newsgroup
> purposes only.
>
> "Stefan" <zericsson@xxxxxxxxxxx> wrote in message
> news:Xns96368DAFD682Cstefanericssonscandi@xxxxxxxxxxxxxxxx
> > Hi,
> >
> > I need help setting up a remote datasource. I got a setup at a client
> > installation that involves.
> >
> > Server 1:
> > Sql 2000
> > Analysis service
> >
> > Server 2:
> > IIS 5.0
> > XMLA 1.1
> > MSXML 4.0
> >
> > Server 3 (on a DMZ net):
> > IIS
> > Snowflake 3.5 (http://www.intellimerce.com/)
> >
> > Problem is I can't get the communication between XMLA and analysis service
> to
> > work. I've setup the datasource to remote by specifying the ipaddress of
> > server 1. Browsing the xmla/msxisapi.dll gives the usual "The Web service
> > supports only the POST operation" answer.
> >
> > I've installer the xmla browser from http://www.reportportal.com on server
> 2.
> > There I get "ClassFactory cannot supply requested class" when opening the
> > first page.
> >
> >
> > Any help or information on setting up remote datasources is appriciated.
> >
> > /Stefan
.

Relevant Pages

  • Re: Using forms authentication to control security access to msolap.asp. Is it possible using ASP.NE
    ... (including the username/pwd coming from your ASP.NET server. ... This uses http connectivity with a known username and pwd. ... SQL BI Product Unit (Analysis Services) ... >> authentication problem is resolved. ...
    (microsoft.public.sqlserver.olap)
  • Re: Relational to DW.?
    ... Analysis Services for some time. ... data on the same server. ... > interesting question......I assume your 'relational database' is for a ... > just finished it but have not put the pointer to it on my web site ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Using forms authentication to control security access to msolap.asp. Is it possible using ASP.NE
    ... authentication problem is resolved. ... The "Pivot Table" component maps to the URL in our IIS server, ... between Analysis Services and the "Pivot Table" component present in some ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Server 2000 Tuning
    ... SQL BI Product Unit (Analysis Services) ... > Microsoft Windows 2000 Advanced Server SP4 ... I have tried ADODB recordsets, ADOMD cellsets, and now we are ...
    (microsoft.public.sqlserver.olap)
  • Re: Pivot table over HTTPS
    ... The latest and greatest is on the SQL Server 2000 Analysis Services SP3 ... it is *EXTREMELY IMPORTANT* that you update your client-side PTS OLEDB ...
    (microsoft.public.sqlserver.olap)