dbTalk Databases Forums  

Ruuning Analysis service over SSL/HTTPS

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Ruuning Analysis service over SSL/HTTPS in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Krishna
 
Posts: n/a

Default Ruuning Analysis service over SSL/HTTPS - 08-30-2006 , 07:15 AM






Hi ,

I have configured analysis service 2005 on windows 2003 server . I am
able to
connect to my analysis service using excel PTS client . Now i have to port
the same service over HTTPS . I have installed the certifcates correctly and
able to
run the aspx/html pages correctly over the https . But when i try to connect
to
analysis service by (https://<servername>/OLAP/msmdpump.dll) on the browser
or excel it gives connection error . I am using basic authentication
currently.
Please help me . Relevent document explaining HTTPS connection for Analysis
service would be a great help .

Regards
Krishna


Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: Ruuning Analysis service over SSL/HTTPS - 08-30-2006 , 07:28 AM






do you use a valid certificate for your SSL?

"Krishna" <Krishna (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi ,

I have configured analysis service 2005 on windows 2003 server . I am
able to
connect to my analysis service using excel PTS client . Now i have to
port
the same service over HTTPS . I have installed the certifcates correctly
and
able to
run the aspx/html pages correctly over the https . But when i try to
connect
to
analysis service by (https://<servername>/OLAP/msmdpump.dll) on the
browser
or excel it gives connection error . I am using basic authentication
currently.
Please help me . Relevent document explaining HTTPS connection for
Analysis
service would be a great help .

Regards
Krishna




Reply With Quote
  #3  
Old   
Krishna.singh
 
Posts: n/a

Default Re: Ruuning Analysis service over SSL/HTTPS - 08-31-2006 , 02:42 AM




I Have valid certificate which i have installed using IIS Certificate
creation wizard. normal pages are rendered OK using https but when i try to
invoke
msmdpump.dll , it starts giving errors . Does excel have the capability to
decrypt
128 bit SSL data coming from IIS server ?

Regard
Krishna

"Jéjé" wrote:

Quote:
do you use a valid certificate for your SSL?

"Krishna" <Krishna (AT) discussions (DOT) microsoft.com> wrote in message
news:F78371AE-5613-4B30-ADC6-EDFAB4D9F581 (AT) microsoft (DOT) com...
Hi ,

I have configured analysis service 2005 on windows 2003 server . I am
able to
connect to my analysis service using excel PTS client . Now i have to
port
the same service over HTTPS . I have installed the certifcates correctly
and
able to
run the aspx/html pages correctly over the https . But when i try to
connect
to
analysis service by (https://<servername>/OLAP/msmdpump.dll) on the
browser
or excel it gives connection error . I am using basic authentication
currently.
Please help me . Relevent document explaining HTTPS connection for
Analysis
service would be a great help .

Regards
Krishna





Reply With Quote
  #4  
Old   
Jéjé
 
Posts: n/a

Default Re: Ruuning Analysis service over SSL/HTTPS - 08-31-2006 , 07:42 AM



are you prompted for a login/password in excel?
or have you saved the login/password in the connection string?

I presume that you have tested the HTTP access and everything works fine
here. (without SSL)
But have you tested HTTP + Basic authentication?

have you try to use the IP address instead-of the DNS name?
what the IIS log files says? do you see the access? what is the HTTP
response?

"Krishna.singh" <Krishna.singh (AT) discussions (DOT) microsoft.com> wrote

Quote:
I Have valid certificate which i have installed using IIS Certificate
creation wizard. normal pages are rendered OK using https but when i try
to
invoke
msmdpump.dll , it starts giving errors . Does excel have the capability to
decrypt
128 bit SSL data coming from IIS server ?

Regard
Krishna

"Jéjé" wrote:

do you use a valid certificate for your SSL?

"Krishna" <Krishna (AT) discussions (DOT) microsoft.com> wrote in message
news:F78371AE-5613-4B30-ADC6-EDFAB4D9F581 (AT) microsoft (DOT) com...
Hi ,

I have configured analysis service 2005 on windows 2003 server . I
am
able to
connect to my analysis service using excel PTS client . Now i have to
port
the same service over HTTPS . I have installed the certifcates
correctly
and
able to
run the aspx/html pages correctly over the https . But when i try to
connect
to
analysis service by (https://<servername>/OLAP/msmdpump.dll) on the
browser
or excel it gives connection error . I am using basic authentication
currently.
Please help me . Relevent document explaining HTTPS connection for
Analysis
service would be a great help .

Regards
Krishna







Reply With Quote
  #5  
Old   
Krishna.singh
 
Posts: n/a

Default Re: Ruuning Analysis service over SSL/HTTPS - 09-01-2006 , 01:11 AM




Thanks Jeje for your help , Certificate was not correct actually . When i put
the local certificate issuer into trusted CA list things worked fine . well
I was using basic authentication . Thanks once more for your help

Regards
Krishna
"Jéjé" wrote:

Quote:
are you prompted for a login/password in excel?
or have you saved the login/password in the connection string?

I presume that you have tested the HTTP access and everything works fine
here. (without SSL)
But have you tested HTTP + Basic authentication?

have you try to use the IP address instead-of the DNS name?
what the IIS log files says? do you see the access? what is the HTTP
response?

"Krishna.singh" <Krishna.singh (AT) discussions (DOT) microsoft.com> wrote in message
news:8C29A2F8-EB29-4496-BC36-DF8634362A89 (AT) microsoft (DOT) com...

I Have valid certificate which i have installed using IIS Certificate
creation wizard. normal pages are rendered OK using https but when i try
to
invoke
msmdpump.dll , it starts giving errors . Does excel have the capability to
decrypt
128 bit SSL data coming from IIS server ?

Regard
Krishna

"Jéjé" wrote:

do you use a valid certificate for your SSL?

"Krishna" <Krishna (AT) discussions (DOT) microsoft.com> wrote in message
news:F78371AE-5613-4B30-ADC6-EDFAB4D9F581 (AT) microsoft (DOT) com...
Hi ,

I have configured analysis service 2005 on windows 2003 server . I
am
able to
connect to my analysis service using excel PTS client . Now i have to
port
the same service over HTTPS . I have installed the certifcates
correctly
and
able to
run the aspx/html pages correctly over the https . But when i try to
connect
to
analysis service by (https://<servername>/OLAP/msmdpump.dll) on the
browser
or excel it gives connection error . I am using basic authentication
currently.
Please help me . Relevent document explaining HTTPS connection for
Analysis
service would be a great help .

Regards
Krishna








Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.