ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Problem of install with remote server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

elbrick

Venezuela
1 Posts

Posted - 07/16/2004 :  04:51:17  Show Profile  Click to see elbrick's MSN Messenger address  Reply with Quote

Hi,

I try to connect XMLA with remote server, the IIS is install in a machine with XP SO and SQLSERVER 2000 is install in a machine with WINDOWS 2000 but this machine haven`t IIS. When i try to connect with the sample program the follow error is show

html><head><title>Site Not Found</title></head>
<body>No web site is configured at this address.</body></html>

In the Connect Form i write the follow DataSource:

Provider=MSOLAP.2;Data Source=http://dt-185/ReportPortal_X

The Datasource file content the follow text:

<?xml version="1.0" ?>


<DataSources UnnamedSessionsTimeout="300" NamedSessionsTimeout="3600" MaxRequestSize="128" AllowInsecureTransport="1" EnableNagleAlgorithm="1">
<DataSource>
<DataSourceName>Local</DataSourceName>
<DataSourceDescription>Microsoft Analysis Server 2000 on local machine</DataSourceDescription>
<URL>http://localhost/xmla/msxisapi.dll</URL>
<DataSourceInfo>Provider=MSOLAP.2;Data Source=http://dt-185/ReportPortal_X</DataSourceInfo>
<ProviderName>Microsoft XML for Analysis</ProviderName>
<ProviderType>
<TDP/>
<MDP/>
<DMP/>
</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
</DataSource>

</DataSources>


What happend?, I need help.


Bye

Elbrick Salazar

admin

1647 Posts

Posted - 07/16/2004 :  21:07:54  Show Profile  Reply with Quote
Dear Elbrick,

1. Did you install PTSFULL.EXE from your SQL server SP 3 on your XP box?
2. Did you install the XMLA SDK 1.1 on your XP box?
3. Did you install MSXML 4.0 on your XP box?
4. Did you enable basic authentication on your XMLA virtual directory or change your anonymous user to have access to the Analysis Services?
5. Are your XP and 2000 computers on the same domain?
6. Did you use XMLA SDK 1.1 Sample Application to test the connection to you XP box (assuming it have XMLA SDK 1.1 installed)

I am not quite sure why you are "Data Source=http://dt-185/ReportPortal_X" in your connection string. Did you place a MSOLAP.ASP in that virtual directory? In any case you should not use HTTP when using XMLA.

Igor
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page