Hi,
I'm working with SQL Server 2005.
I have a problem with the remote connection to the Analysis Services component of a remote Windows Server 2003. I have enabled remote connections from Surface Area Configuration and I have enabled TCP/IP, VIA, Shared memory, etc, protocols.
I have read the SQL Browser is shared between the Database Engine and the Analysis Services, and for this, according which one is running, the SQL Browser is listening through a port or another (1432 for Database Engine and 2382 for Analysis Services, if I get it right).
For checking whether port 2382 is listening I do telnet from my computer and it's ok.
Of course, Analysis Services, SQL Browser are running (really, all the services are running now).
My problem comes when I try to implement a project with SQL Server Business Intelligence Development Studio. I create a new Analysis Services project, in the project properties I've write the name of the server (NAMESERVER/instance), I've established as a datasource the MS database example (AdventureWorksDW) and until here everything is correct, I generate the project and it's OK. But when I implement the project I get an error like this:
'Can not establish a connection. Make sure the server is running'
And the same it happens when I try: "File --> Open --> Analysis Services database..." I write the server name and I get the same error.
Please I need your help. Do somebody know what might be happening?
Thankss!
PD: Sorry for my bad english. I'm spanish ;-)
