Ruuning Analysis service over SSL/HTTPS

[Database Administrator]

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:///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

[Database Administrator]

do you use a valid certificate for your SSL?

"Krishna" wrote in message
news:F78371AE-5613-4B30-ADC6-EDFAB4D9F581@microsoft.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:///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
>

[Database Administrator]

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" wrote in message
> news:F78371AE-5613-4B30-ADC6-EDFAB4D9F581@microsoft.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:///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
> >
>
>
>

[Database Administrator]

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" wrote in message
news:8C29A2F8-EB29-4496-BC36-DF8634362A89@microsoft.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" wrote in message
>> news:F78371AE-5613-4B30-ADC6-EDFAB4D9F581@microsoft.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:///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
>> >
>>
>>
>>

[Database Administrator]

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:

> 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" wrote in message
> news:8C29A2F8-EB29-4496-BC36-DF8634362A89@microsoft.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" wrote in message
> >> news:F78371AE-5613-4B30-ADC6-EDFAB4D9F581@microsoft.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:///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
> >> >
> >>
> >>
> >>
>
>
>

[Sharki.Chacko]

Hi Krishna,

Have you configured IIS with "Required Client Certificate" option? so that Excel can access SSAS cubes securely. Even I was able to access cube using https but default, IIS is configured to ignore client certificates from browser. Can you tell me how you are able to access cube from Excel over HTTPS?


Thanks in advance.
Sharki.

[Sharki.Chacko]

Hi Krishna,


Can you tell me how did you able to connect to the server from excel over https in but detailed? Even I was able to connect to the server but later I realized that the "Require client certificate" option on server is not enabled for secure communication. If this option is disabled, the communication between client and server will be unsecured. When I enabled this option, excel started giving me errros. Have you gone through this scenario before?


Thanks in advance,
Sharki