Heard this is possible on Enterprise Edition, but how do we make a
connection from SQL Management Studio on domain A to AS2005 box on
domain B, where there is no trusted relationship between domains A and
B?

Seems like Mgmt Studio automatically prefixes the domain (username box
is prepopulated with domain A\current login and grayed out when I
select Analysis Services) so I can only connect to AS servers on the
domain I am already on.

Any help would be much appreciated, thanks

try to connect your computer to a shared folder on the remote server
and after open mgmt studio.

or try to starts mgmt studio using the runas command line
runas /netonly /user:<remote domain>\<remoteuser> "mmc mgmt.msc" (I'm not
sure for the syntax)

<cbartlett00 (AT) yahoo (DOT) com> wrote

thanks, I can runas using my domain B account, but when I pull up the
AS connection dialog it's still prepopulated with my current win logon
domain (domain A).

connecting to AS from mgmt studio support only NT authentication.
You can't change the login used.

You should be able to access the remote server using the RUNAS command and
the windows authentication method, in this case the current context is not
your current windows conetxt but the one specified in the runas. (in theory
:-) )

to access the remote server for analysis like an end user. you have to use
Excel for example amd access the remote server using the HTTP XML/A access +
basic authentication method to prompt the user for a login/password.

last option:
you have to setup an account on domain B with the EXACT login name and
password used in domain A
If the same login/password exists on the remote domain, then you can access
the remote resources.

<cbartlett00 (AT) yahoo (DOT) com> wrote