dbTalk Databases Forums  

Connection from IIS to Analysis Services

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


Discuss Connection from IIS to Analysis Services in the microsoft.public.sqlserver.olap forum.



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

Default Connection from IIS to Analysis Services - 11-02-2004 , 08:43 AM






Hello,

We have a web application running in server 1 (Win2000) that execute some
querys to Analysis Services running in server 2 (Win2000 same domain).

When the application execute a query, a windows login and password is asked
to the user. I don't want that this login forms shows. How can I do that?

Thank you

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Connection from IIS to Analysis Services - 11-02-2004 , 10:24 AM






Your web application must be configured so it has a valid NT account
credential with the Analysis server. When Analysis Services runs it will
impersonate that NT account for its security checking.

This is comparable to using a trusted connection with SQL Server. All of the
same rules apply, e.g. it must be a common domain account; it can't be more
than one hop; etc.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

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

Quote:
Hello,

We have a web application running in server 1 (Win2000) that execute some
querys to Analysis Services running in server 2 (Win2000 same domain).

When the application execute a query, a windows login and password is
asked
to the user. I don't want that this login forms shows. How can I do that?

Thank you



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.