SQL Server Performance Forum – Threads Archive

connection to server failed

Hi guys,
I’m registering a new server under analysis services. but whenever i do this i get an error as error occurred while conecting to dscp04223.
You are not a member of the OLAP Administrators group on this server.
But i have already added my LanID on that server in administrator and olap administrator.
What is going wrong.
My support team said it can be related to service pack issue.
Plz guys help me connect to that server.[?]

yes they are right
http://support.microsoft.com/default.aspx?scid=kb;en-us;814414

Hi dinesh,
Thanx for the useful link, because of that link i found many other links.
As MS says sp4 has fixes for memory leaks too.
And i was facing such leaks from last 10 days.
So i feel better option is to go for sp4.
But still worried that sp4 should not create other issues and should not
crash down.
Well the project is going live in two days time.
So im afraid whether to go for sp4 or not yet.

]]>