dbTalk Databases Forums  

Re: web access to a cube

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


Discuss Re: web access to a cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: web access to a cube - 04-16-2004 , 02:35 PM






Technically it does not if you are running SP3. If prior to SP3, then it is
required that they are on the same machine
Look at:
http://msdn.microsoft.com/library/en...l_datapump.asp
for more details.

However, if using NTLM security -- i.e. you are using the client's NT
account for security access, then you *must* have either IIS and Analysis
Services on the same machine or configure your machines for Kerberos account
delegation (which is quite difficult and requires considerable changed to
your NT domain infrastructure). Normal NT credentials can only travel one
hop -- in this case, from the client to the IIS server. Without Kerberos,
you cannot then transfer them a second time to the Analysis server -- this
is a NT restriction that you will run into using file shares, SQL Server
RDBMS, MS Exchange, or any network protocol. Thus the recommended technique
is to run them together.

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


"Frank Spencer" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
If you use excel as a client tool and enable web access with
interactivity, does the IIS server have to be on hte same box as the AS box?
TIA,
Frankie



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.