Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
XML
data.xmlanalysis
mappoint.webservice
msf
msxml-webrelease
netmyservices.sdk
passport.sdk
soap
soapsdk
uddi.general
uddi.programming
uddi.specification
xml
xmlsqlwebrelease
xsl
  
 
date: Thu, 24 Nov 2005 16:39:22 +0100,    group: microsoft.public.data.xmlanalysis        back       


secure ssl connection with xmla   
Hi,

i try to get an secure connection to my analysis server enterprise 
edition over internet with xmla!

I tried the connection with XMLA Sample App over http, that works. But 
if i try it with https it doesnt. Whats wrong?

What i did:
1.)I Installed SQL Server 2000 and Analysis Server with SP4 (enterprise)
2.)I installed MSXML 4.0
3.)I installed XMLA SDK (connection via unsecure http disabled--> only 
https)
4.)datasources.xml
-------------------SHORT-Version------------
AllowInsecureTransport="0"
<URL>https://MYWEBSERVER.COM/xmla/msxisapi.dll</URL>
<DataSourceInfo>Provider=MSOLAP.2;Data 
Source=MYWEBSERVER.COM</DataSourceInfo>

-------------------Long-Version------------
<DataSources UnnamedSessionsTimeout="300" NamedSessionsTimeout="3600" 
MaxRequestSize="128" AllowInsecureTransport="0">
	<DataSource>
		<DataSourceName>Local Analysis Server</DataSourceName>
		<DataSourceDescription>Microsoft Analysis Server 2000 on local 
machine</DataSourceDescription>
		<URL>https://MYWEBSERVER.COM/xmla/msxisapi.dll</URL>
		<DataSourceInfo>Provider=MSOLAP.2;Data 
Source=MYWEBSERVER.COM</DataSourceInfo>
		<ProviderName>Microsoft XML for Analysis</ProviderName>
		<ProviderType>
			<TDP/>
			<MDP/>
			<DMP/>
		</ProviderType>
		<AuthenticationMode>Unauthenticated</AuthenticationMode>
	</DataSource>	
</DataSources>
-------------------Long-Version------------

5.IIS
5.1)New Virtual Directory--> XMLA/ISAPI
	Permissions:Read/Scripts and Executable
	Authentication: Anonymous (if all will work, i will change it to Basic)
5.2)New Webservices:
XMLA; msxisapi.dll enabled

6.)Firewall deactivated (if all will work, i will change it open only 
port 443)

7.)I Installed a selfsigned certificate SELFSSL.exe from MS IIS ressources

8.)Analysis Services
8.1)Foodmart permissions changed to EVERYBODY

9.)XMLA Sample APP
9.1)http://MYWEBSERVER.COM/xmla/msxisapi.dll works
(but changings in datasources.xml)
-------------------SHORT-Version------------
AllowInsecureTransport="1"
<URL>http://MYWEBSERVER.COM/xmla/msxisapi.dll</URL>
<DataSourceInfo>Provider=MSOLAP.2;Data 
Source=MYWEBSERVER.COM</DataSourceInfo>

9.2)https://MYWEBSERVER.COM/xmla/msxisapi.dll doesnt work, why?
-------------------SHORT-Version------------
AllowInsecureTransport="0"
<URL>https://MYWEBSERVER.COM/xmla/msxisapi.dll</URL>
<DataSourceInfo>Provider=MSOLAP.2;Data 
Source=MYWEBSERVER.COM</DataSourceInfo>


whats my failure?

thx
Sefer
date: Thu, 24 Nov 2005 16:39:22 +0100   author:   sefe dery

Re: secure ssl connection with xmla   
> 9.2)https://MYWEBSERVER.COM/xmla/msxisapi.dll doesnt work, why?
> -------------------SHORT-Version------------
> AllowInsecureTransport="0"
> <URL>https://MYWEBSERVER.COM/xmla/msxisapi.dll</URL>
> <DataSourceInfo>Provider=MSOLAP.2;Data 
> Source=MYWEBSERVER.COM</DataSourceInfo>
> 
Failure Message: "The Download for indicated resources 
failed"(translated from german)
date: Thu, 24 Nov 2005 16:47:42 +0100   author:   sefe dery

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us