I must be missing something...
On my Windows XP SP2 development box I have SQL 2005 Standard and
VS2005. I have built an analysis service project and deployed it to
the server on my box. All works well from SSRS, Excel (OLE DB Provider
for Analysis Services 9.0), SQL Management Studio and BIDS. However, I
cannot connect via Excel or SQL Management Studio to the deployed SSAS
from another computer on the network (I want my users to "play" with
the cube via Excel just to get comfortable with the technology). I
have configured the Surface Area to allow remotes connections and have
disabled the firewalls. The (seemingly) strange thing is that in SQL
Management Studio if I attempt to connect to Databases, it gives me an
option to browse for both network and local servers. However, if I
connect to Analysis Services servers, I only have an option to look for
local servers. So what am I missing???

Tom

talk about how you are authenticating..

do you know anything about double-hop??

i would assume it's a simple double-hop issue

Double-hop is an IIS authentication issue with ASP.NET as I understand
it. In the above, I'm not (as far as I know) attempting to use IIS.
In SQL Management Studio, all I want to do is connect to a remote
analysis server the same way I connect to a remote database server.
Additionally, in Excel, all I'm attempting to do is establish a
Database Query to an OLAP server. In both cases, it works on the local
machine, but not remote. So, a first question is should I be able to
access the OLAP server the same fundamental way I access a database
server? If not, then how is it done?

Thanks,
Tom

double-hop also effects you.. say.. when you're connecting to a linked
server in SQL 2000 relational. That has nothing to do with IIS.
You can't double-hop authentication unless you run SETSPN... and you
set your AD accounts to 'trusted for delegation'.

this just sounds like a double-hop problem.. but it's probably
something much simpler

#1) have you installed the clientside requirements to connect to SSAS
2005 via Excel? What is it; olap drivers version 9, MSXML v6; etc?

#2) is your firewall on?

#3) i believe that you need to enable remote connections...
under <computer management>, <services and applications> you need to
make sure that
<SQL Server Configuration Manager>, choose <Protocols for MSSQLSERVER>
and enabled TCP/IP

I _THINK_ that i saw that 'shared memory' was the default connection;
and you'll want to use TCP/IP for remote connections?

i wish i could say this was a definite answer; i just remember i had
some hard time with something like that; we've got so many servers
around here that i dont know what the default setting is.

i just know i had to go in their once and do that.

In order...
1) The driver is installed. Excel works using version 9 for a local
host, but not remote.
2) I've turned the firewalls off just to rule that out
3) TCP protocols are enabled

An additional point; for our development environment, we are in a
workgroup as opposed to a domain. Any thoughts about that being a
problem?

Thanks again!

This could be what is causing your issue. In a workgroup I think the
only way you could get remote clients to authenticate would be to setup
accounts on your "server" machine with the same username and passwords
that the client are using on their machines. Then on the "server" you
would need to make sure these accounts were in appropriate roles in AS
2005 to have permission to browse the cubes.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1140181257.837961.16010 (AT) o13g2000cwo (DOT) googlegroups.com>,
tlehmkuhl (AT) forte-industries (DOT) com says...

or enabling the guest account and giving the guest account permissions
to your database


or better than guest; i think that you can use 'network'
im kindof fuzzy on the details; but i think that network is more secure
than guest