Re: Cannot connect to AS2005 remote server

On Dec 19, 2:18 pm, "Christophe Niel"
<Christophe.N...@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hum...

http://support.microsoft.com/kb/912017/en-ussays if you don't have enough
memory, the connection may fail

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL20...
gives you scenarios

ensure you have the SQL Browser started on XP if you have a named instance.

and try to access your cube with excel and/or test with a .UDL file, it will
give you other error messages to test

finally, I really like this resolution from microsoft :http://technet2.microsoft.com/Office/en-us/library/5a286d02-2ddb-4a48...
(thanks google)

cause "the server is not running", resolution "start the server"... :D

Hope that helps

"alejandro" <alejan...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message

news:98CB94CE-F40C-40AE-AB2F-ADAEE668581E@xxxxxxxxxxxxxxxx



Hi, I have SQL 2005 Analysis Services running in a WXP Pro SP2 machine.
The security in this server is "Everyone" and "guest".
Then in other machine (Windows Server 2003 SP1) I have installed "SQL
Server
Management Studio".
When I try to connect to the database server (SQL Server 2005), I have no
problem. I can connect perfectly.
But, when I try to connect to the AS2005 server from SQL Server Management
Studio I get this error message:

Error detail:
TITLE: Connect to Server
------------------------------
Cannot connect to SERVERNAME.
------------------------------
ADDITIONAL INFORMATION:
A connection cannot be made. Ensure that the server is running.
(Microsoft.AnalysisServices.AdomdClient)
------------------------------
Unable to read data from the transport connection: An existing
connection was forcibly closed by the remote host. (System)
------------------------------
An existing connection was forcibly closed by the remote host (System)
------------------------------
BUTTONS:
OK
------------------------------

Thanks for help

Alejandro- Hide quoted text -

- Show quoted text -

I, too, was having this problem and spent three days searching for an
answer. My scenario: Unable to connect to remote instance of SSAS,
either with SSMS or through the BI Studio from my Windows XP client to
Windows 2003 remote server. I was receiving the same errors -

I came across my solution accidentally. I was trying to access a
shared, mapped directory on this same server through the Explorer and
could not - was continually prompted for domain creds but not able to
access.

I went to Control Panel, User Accounts, Advanced tab, Manage
Passwords. My organization requires domain password updates every 90
days - my old domain password was apparently stored for this server.
I removed the server from the list of stored passwords and my problems
with connecting to SSAS (and other apps on this server) were resolved.

May not be much help - but wanted to throw it out there - there are
some fairly technical solution suggestions all over the web that did
not do the trick.
.