dbTalk Databases Forums  

Re: accessing AS 2005 from ASP.NET application

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


Discuss Re: accessing AS 2005 from ASP.NET application in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: accessing AS 2005 from ASP.NET application - 11-17-2005 , 04:54 PM






It is also possible to map application users to AS users/roles by means of
using either EffectiveUserName property or Roles property (this is more
similar to SQL Server application roles), and it gives enough flexibility.

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =

<anonymous_user (AT) sqlserverdatamining (DOT) com> wrote

Quote:
Thanks for the reply ....Wht i want to know

Here i want to connect to Ananlysis services 2005 from asp.net application
running on a different server...
Since AS 2005 allows only windows authentication, what would be the easier
to implement and deploy scenario?
1) Using kerberos
2) creating a webservice with some Identity to access AS 2005 and using
an agent in the application;
3) some other mechanism.

Has AS 2005 came with some mechanism to allow easy access from web
applications (just like sql server authentication in SQL 2005). Is there
any feature that we could use? What about anonymous access?

Thanks in advance....


If you can't set up delegation, you should be able to run the ASP.NET
application in an application pool running as a domain user. Then you
can
give the domain user the proper permissions on the server.

--

-Jamie MacLennan
SQL Server Data Mining
This posting is provided "AS IS" with no warranties, and confers no
rights.
"Abhi" <Abhi (AT) discussions (DOT) microsoft.com> wrote in message
news:1D84B1DB-6468-43D0-907A-CF1438D49609 (AT) microsoft (DOT) com...
I have an asp.net application. This application provide consolidated
information to the user using Analysis Services 2005.
Within it, one aspx page uses MDX query to retrieve the information
from
the
cube. However, we are unable to access AS 2005 because of
authentication
issues. What would be the easier to implement and deploy scenario?

How can I access AS 2005 from an ASP.NET application? Is there any
feature
to use?






Reply With Quote
  #2  
Old   
Abhi
 
Posts: n/a

Default Re: accessing AS 2005 from ASP.NET application - 11-18-2005 , 12:32 AM






can u please refer me some linke that talks about implementing the same......

"Mosha Pasumansky [MS]" wrote:

Quote:
It is also possible to map application users to AS users/roles by means of
using either EffectiveUserName property or Roles property (this is more
similar to SQL Server application roles), and it gives enough flexibility.

--
==============================Â*================== ==
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLÂ*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================Â*================== ==

anonymous_user (AT) sqlserverdatamining (DOT) com> wrote in message
news:cac6c280-a037-4809-8e66-62cbe8b38e04 (AT) msnews (DOT) microsoft.com...
Thanks for the reply ....Wht i want to know

Here i want to connect to Ananlysis services 2005 from asp.net application
running on a different server...
Since AS 2005 allows only windows authentication, what would be the easier
to implement and deploy scenario?
1) Using kerberos
2) creating a webservice with some Identity to access AS 2005 and using
an agent in the application;
3) some other mechanism.

Has AS 2005 came with some mechanism to allow easy access from web
applications (just like sql server authentication in SQL 2005). Is there
any feature that we could use? What about anonymous access?

Thanks in advance....


If you can't set up delegation, you should be able to run the ASP.NET
application in an application pool running as a domain user. Then you
can
give the domain user the proper permissions on the server.

--

-Jamie MacLennan
SQL Server Data Mining
This posting is provided "AS IS" with no warranties, and confers no
rights.
"Abhi" <Abhi (AT) discussions (DOT) microsoft.com> wrote in message
news:1D84B1DB-6468-43D0-907A-CF1438D49609 (AT) microsoft (DOT) com...
I have an asp.net application. This application provide consolidated
information to the user using Analysis Services 2005.
Within it, one aspx page uses MDX query to retrieve the information
from
the
cube. However, we are unable to access AS 2005 because of
authentication
issues. What would be the easier to implement and deploy scenario?

How can I access AS 2005 from an ASP.NET application? Is there any
feature
to use?







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.