I have the following setup:

- Windows XP machine with SQL management studio and Business
intelligence studio installed not part of a domain.
- Windows 2000 server running SQL2005, analysis service started, not
part of a domain.

How can I connect the SQL management studio and Business intelligence
studio of XP to the analysis service of the Windows 2000 machine?

I already tried:

- declaring a port to use for the analysis service and connecting to
that port from the xp machine.
- allowing anonymous access on the analysis service.

I searched this group and found others having this problem (dated from
2005). They speak of HTTP access, is that the only way to do it? Will
that work to connect BI studio as well? Or has MS changed anything
since?


--
Thanks in advance for any help,

Stijn Verrept.

I have the same problem........



"Stijn Verrept" <TURN_moc.tfosyrtne@njits_AROUND> wrote

(sorry if double post, playing with newsreaders)

I don't believe anything has changed. AS2005 is coupled with Windows
Authentication very tightly (rather unfortunately, I believe). I find a
Remote Desktop like solution is the best bet when your client and server
don't share a domain (or don't even know how to connect to the other domain)
as appears to be your setup.

I got so fed up jumping through hoops I had to setup a bogus ActiveDirectory
on my LAN just for AS2005.

-z


On 7/19/06 7:26 PM, in article #Z27NQ6qGHA.2108 (AT) TK2MSFTNGP03 (DOT) phx.gbl,
"Rubens Naves" <rubensnaves (AT) hotmail (DOT) comm> wrote:

Here's the solution I came up with.

Instead of taking the Custom Authentication route, I resigned to using
windows authentication.

I impersonate a windows user on the target server:

<add key="myKey" value="Data
Source=server\instance;Provider=MSOLAP;Initial Catalog=InitialDatabase;
uid=UserOnServer; pwd=PasswordOnServer;"/>

this key is passed to the connection object, and it impersonates that
user correctly...


Alternatively, you could grant access to Everyone, not Anonymous...
that way when you connect without impersonation, which is probably the
Network Service account, you will be granted access..
Hope this helps.
- Lawren