Analysis Services 2005 is not getting connected

All,

I am running Windows 2003 Server Standard Edition. Installed SQL Server 2000 and SP4 with default instance.

Installed SQL Server 2005 including analysis services with named instance (SQL2005).

Able to connect to SQL Server 2005. But when i am trying to connect to analysis services with

Windows authentication and server name as "UKPRESALES1\SQL2005".

Getting an Error : "A connection cannot be made to redirector. ensure that sqlbrowser service is running."

Pls suggest me. Finally I ended up in un-installing everything and trying out.

Raja.

Have you read the following paper on AS connectivity problems?

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspx

It could be a firewall problem...

HTH,

Chris

|||

Indeed, please make sure that both Analysis Services 2005 (msmdsrv.exe) and SQL Browser are allowed in the firewall to accept connections (related article here: http://msdn2.microsoft.com/en-us/library/ms175638.aspx).

|||

hello chris,

Windows Firewall have been disabled already. That too i am trying to connect in the local machine. Even the Sql browser service is running under local account.

As of now i am trying to install sql 2005 in default instance. Later I will install Sql 2000 with named instance.

Pls help me if any other solution is available.

Rajas.

|||So, to be clear - you can't connect even from the same server that you've installed AS on?