i have to implement an olap server inside of different domain.

these domains dont have trusts, and they can't--

i can't figure out the best architecutre here.

Just pretend for a second, that this is my arch.

1) i work in a domain called happy
2) the datamart is in a domain called sad
3) to get to sad, i have to TS using my sad account and from there, I only
have access to machines on the sd domain.
4) i plan on putting the OLAP inside the sad domain.

i just need to be able to:

a) get to the OLAP data from either happy or sad domain.
b) not use SQL permissions
c) not change AD

should i just focus on getting the DM out of the sad domain and into the
happy domain?

might SQL 2005 have an improvement in this aspect?

aaron

This is discussed extensively in these two white papers:
http://www.microsoft.com/technet/pro.../anservog.mspx
(in the Security Administration section)
http://msdn.microsoft.com/library/de...l_datapump.asp

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

<aaron_kempf (AT) hotmail (DOT) com> wrote