RE: ASP .Net connect to OLAP using OWC

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: James (James_at_discussions.microsoft.com)
Date: 08/29/04 

Date: Sun, 29 Aug 2004 02:27:04 -0700

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]" wrote:

> 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.
>
>

Relevant Pages

  • Re: OLAP-Client not in Domain
    ... Great Information Dave. ... What would the connection string look like? ... Is telling my database services group to drop my server and re-install ... > SQL BI Product Unit (Analysis Services) ...
    (microsoft.public.sqlserver.olap)
  • Re: Connecting to AS 2005 using a specified user
    ... specifying MSOLAP.2 in the connection string has no effect ... when connecting from Excel. ... AS2005 is the same userID specified in the HTTP connection string, ... > Basic authentication credentials. ...
    (microsoft.public.sqlserver.olap)
  • RE: Linked server with mirrored database 2
    ... In the connection string, it is allowed ... could you please tell me the reason for using both windows authentication ... we can consider the Server A as the client. ... To ensure our connection security, it is allowed to definate only one ...
    (microsoft.public.sqlserver.setup)
  • Re: Persisting user login credentials across pages
    ... In ASP.Net 1.1 most people add the connection string to the web.config file. ... "Siobhan" wrote in message ... >> Sample code requires you to have a login method on your Principal class ... >>> I am not sure how Forms authentication would work - the sample using ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to prevent connection string from user?
    ... I directly send connection string to DB then another ... > can filter my account and password. ... When you want to connect with Windows authentication, ... the desired SQL Server login needs to be specified. ...
    (microsoft.public.sqlserver.security)