| Author |
 Topic  |
|
|
sefer
Germany
105 Posts |
 Posted - 11/24/2005 : 08:29:35
|
Hi,
i wrote this in the newsgroup:
microsoft.public.data.xmlanalysis
---------------------------------
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?
-----------------------------------------
and after this, i changed the settings to http connection in datasources.xml like this
AllowInsecureTransport="1"
<URL>http://MYWEBSERVER.COM/xmla/msxisapi.dll</URL>
<DataSourceInfo>Provider=MSOLAP.2;Data Source=MYWEBSERVER.COM</DataSourceInfo>
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
http://MYWEBSERVER.COM/xmla/msxisapi.dll
to
https://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
|
|
|
admin
1646 Posts |
|
|
sefer
Germany
105 Posts |
Posted - 11/29/2005 : 06:17:02
|
Hi,
all seems to be working.
I closed the port 80 in my firewall and opened only 443.
my connection begins allway with https and the LOCKKEY in IE appears!
I think all is now SSL-secured, or isnt it?
Im able to connect to AS from every Report portal-site.
thx
Sefer |
 |
|
| |
Topic |
|
|
|
Report Portal
Secure SSL connection over internet
