I've run into a problem with connecting directly via excel 2003 to my cubes
for some users external to my domain.

We're using AS2000 std edition, so http is not an option.

Internal to our domain, there are no issues with connecting to the cubes,
however external to our domain, it's hit and miss.

We've created domain accounts for external users to connect to AS2000. From
home, I have no problems at all connecting to the cubes. As does a few other
customers of ours, however our head office, on a seperate domain, cannot
connect at all.

When some external users attempt to connect to the cubes, they open the data
connection wizard and input the ip address of the correct server, then select
'Use the following username and password' and provide the correct
credentials, however the security logs shows that their host domain
credentials are being passed and not what they inputted.

Can anyone tell me where I need to look to resolve this issue?

Regards,

Anatoli

I've managed to connect to our AS2000 server from our Head office, however I
logged onto the pc using the local SAM and not onto the domain, established
my VPN and all was well and was able to connect.

"Anatoli" wrote:

Answering your other question

Analysis Services only support windows authentication when connecting using
TCP/IP.
Specifying username and password as part of the connection string will only
work when connecting using HTTP. IIS will authenticate user using
credentials you pass as a connection string.
You have several options. One is to upgrade to Ent edition of AS2000. The
second option is to upgrade to AS2005. In AS 2005 Std edition supports HTTP
connectivity.

Hope that helps.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.





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

Edward,

Can you tell me how I'm able to connect to AS2000 std ed without using http?
I am able to connect from my home domain just fine to all cubes not using
http. We currently only use TCP/IP. Is that indicative of a bug that
shouldn't be happening?

regards,

Anatoli

"Edward Melomed [MSFT]" wrote:

There is no magic trick.
AS2000 ( as well as AS2005 ) will allow you to use Windows authentication
only when connecting via TCP/IP.

If you are able to connect to Analysis Server from your machine ( doesn't
matter if you are at home or on the other side of the planet ) that means
Analysis Server was able to verify your identity. That can happen if you are
running some kind of VPN or established some kind trust relationships
between domains.
Cannot claim to be an expert in the way windows authentication works,
Analysis Sever behaving in the same way any other application using Windows
authentication does. There is nothing specific in this case regarding
Analysis Services.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.


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

Edward,

Is there someone you can ask about this? I've been chasing my tail to try to
determine which settings are allowing me to connect from home and what might
be preventing the folks at our head office from connecting. We are all using
TCP/IP.

regards,

Anatoli

"Edward Melomed [MSFT]" wrote: