ASP .Net connect to OLAP using OWC

[James]

Reference to the article

"Build an OLAP Reporting App in ASP.NET Using SQL Server
2000 Analysis Services and Office XP"

posted at

http://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/

I have this problem, everytime the web services connect to
the Analysis server, user id and password must be supplied
in the connection string.

There is no way for me to read the client PC password, any
solution?

 

[Wei-Dong XU [MSFT]]

Hi James,

When the connection string of OLAP is sent to the server side, the server
will try to connect with Analysis service server with the credential in the
connection string. The authentication of web service and OLAP is not the
same; so we will need to provide the user credential in the connection
string.

Please feel free to let me know if you have any question.

Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[James]

Thanks, but to code the user ID and password in the connection string isn't
that practical. However, I found a .ppt slide from the internet titled
"Implementing Security in Analysis Services 2000" by Richard Tkachuk and
Mosha Pasumansky. It explains several authentication scenarios, and
recommended the use of Kerberos authentication.

It can be done by specifying Provider=msolap;SSPI=Kerberos in the connection
string. I tried it and it serves the purpose since I have already
authenticate users in my web site using Windows Authentication. But on the
other hand, have another problem which is that the connection retrurn error
if the OLAP server is busy. Anyway to increase the time-out value?

 

[Wei-Dong XU [MSFT]]

Hi James,

For the timeout setting, I'd suggest you can add one "Connect Timeout"
property in the connection string. The kb article below contains one sample
for you.
PivotTable component connecting to OLAP server cube appears to stop
responding in Office XP and in Office 2003
http://support.microsoft.com/?id=814030

Please feel free to let me know if you have any question.

Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[James]

Thanks.

 

[Wei-Dong XU [MSFT]]

Hi James,

You are welcome!

Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.