SQL Server Performance

connection to server failed

Discussion in 'Analysis Services/Data Warehousing' started by ranjitjain, Jun 29, 2005.

  1. ranjitjain New Member

    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.[?]
  2. dineshasanka Moderator

  3. ranjitjain New Member

    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.

Share This Page