Sunday, March 11, 2012

Connection to the server is lost.

Hi
I have just installed SQL Server 2000 SP3 on 2000 server
.. I am attempting to connect to the Server through the
Analysis Manager, and I am getting an error of:
Cannot connect to the Analysis server on
computer 'computer name'
Connection to the server is lost.
I am able to connect if I use a administrator ID.
Using my ID I can connect using the Enterprise Manager to
the SQL server. On the server itself, I can't get into
Analysis Manager. Can anyone help?
My ID is listed inside the OLAP Administrators local group
on the server.
One more thing is after SP3 instllation, I have installed
and uninstalled EXCEL 2003. To get rid of one
error "version may not be valid" while connecting from
EXCEL To ANalysis Manager. Now this message has gone.
Thanks in advance for any help regarding this
Regards
Sajith
.Have you applied SP3 for SQL and Analysis Services on your client as well as
the server ?
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Sajith S" <sajith_sudhi@.hotmail.com> wrote in message
news:1229a01c3f5e1$94476720$a401280a@.phx
.gbl...
> Hi
> I have just installed SQL Server 2000 SP3 on 2000 server
> .. I am attempting to connect to the Server through the
> Analysis Manager, and I am getting an error of:
> Cannot connect to the Analysis server on
> computer 'computer name'
> Connection to the server is lost.
> I am able to connect if I use a administrator ID.
> Using my ID I can connect using the Enterprise Manager to
> the SQL server. On the server itself, I can't get into
> Analysis Manager. Can anyone help?
> My ID is listed inside the OLAP Administrators local group
> on the server.
> One more thing is after SP3 instllation, I have installed
> and uninstalled EXCEL 2003. To get rid of one
> error "version may not be valid" while connecting from
> EXCEL To ANalysis Manager. Now this message has gone.
> Thanks in advance for any help regarding this
> Regards
> Sajith
> .
>|||I did. But still the same error message.
So I have done the following workarounds
1. Uninstalled Analysis manager, Deleted the Olap
Administrators ID.
2. Installed Analysis Manager,Olap Administrator ID
created again by Analysis Manager. Applied SP3a.
Now everything found to be working...Thanks for the help.

>--Original Message--
>Have you applied SP3 for SQL and Analysis Services on
your client as well as
>the server ?
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"Sajith S" <sajith_sudhi@.hotmail.com> wrote in message
> news:1229a01c3f5e1$94476720$a401280a@.phx
.gbl...
to
group
installed
>
>.
>

No comments:

Post a Comment