| T O P I C R E V I E W |
| elbrick |
Posted - 07/16/2004 : 04:51:17
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 |
| 1 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 07/16/2004 : 21:07:54
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 |
|
|
Report Portal
