Report Portal

All Forums  ReportPortal General Forum  Report Portal General Issues  Secure SSL connection over internet

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Message: * HTML is ON * Forum Code is OFF Smilies [quote][i]Originally posted by sefer[/i] [br]<font color="red">Hi, i wrote this in the newsgroup: microsoft.public.data.xmlanalysis <font color="green">--------------------------------- 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? -----------------------------------------</font id="green"> and after this, i changed the settings to http connection in datasources.xml like this <font color="black"> AllowInsecureTransport="1" <URL>http://MYWEBSERVER.COM/xmla/msxisapi.dll</URL> <DataSourceInfo>Provider=MSOLAP.2;Data Source=MYWEBSERVER.COM</DataSourceInfo> </font id="black"> In my Windows Firewall i blocked Port 80 and opened 443 for SSL. If i try now to connect to RP2 with http that doesnt work, but if i opened the site with https it works and "thats the strange thing" i am able to get a connection to foodmart over xmla. RP2 changes automatically the connection from <font color="blue">http</font id="blue">://MYWEBSERVER.COM/xmla/msxisapi.dll to <font color="blue">https</font id="blue">://MYWEBSERVER.COM/xmla/msxisapi.dll Does this mean, that i have a secure ssl connection? Anf if it is so, why i get a failure if i try to connect with XMLA Sample App (https)? thx for answer Sefer </font id="red"> [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.