dbTalk Databases Forums  

no connection to Analysis Server but connects to SQL server

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss no connection to Analysis Server but connects to SQL server in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Alexander
 
Posts: n/a

Default no connection to Analysis Server but connects to SQL server - 11-04-2004 , 07:24 AM






SQL Server 2000+ Analysis Server - both on the same W2k3 Server
SQL Server and Windows Authentication - I defined user name and password to
connect to SQL Server and it works fine (the user is member of SysAdmin
Role)

But when i try to connect my workstation to Analysis Server (or even
register it) within Analysis Manager I get the only message:

Unable to connect to the registry on the server (SERVERNAME) or you are not
a member of the OLAP Administration group on this server

May be the error occurs because my workstation is member of domain while
W2k3 Server isn't?

Alexander
alba (AT) ineonet (DOT) net



Reply With Quote
  #2  
Old   
Miguel Salles
 
Posts: n/a

Default RE: no connection to Analysis Server but connects to SQL server - 11-04-2004 , 10:34 AM






The Domain stuff can always be a issue, however, maybe you should look the
connection string on the wks. Also, verify that the user you're using on wks
is part of the (local) "OLAP Administrators Group" on your W2k3.
Good luck

"Alexander" wrote:

Quote:
SQL Server 2000+ Analysis Server - both on the same W2k3 Server
SQL Server and Windows Authentication - I defined user name and password to
connect to SQL Server and it works fine (the user is member of SysAdmin
Role)

But when i try to connect my workstation to Analysis Server (or even
register it) within Analysis Manager I get the only message:

Unable to connect to the registry on the server (SERVERNAME) or you are not
a member of the OLAP Administration group on this server

May be the error occurs because my workstation is member of domain while
W2k3 Server isn't?

Alexander
alba (AT) ineonet (DOT) net




Reply With Quote
  #3  
Old   
Alexander
 
Posts: n/a

Default Re: no connection to Analysis Server but connects to SQL server - 11-05-2004 , 05:42 AM



Hi Miguel
thank your for your assistance - it helped me to learn more about MS
SQL+OLAP stuff.

I figured out - I had to have the same service packs on both - W2k3 server
and client rworkstation unning Analysis manager. After I installed sp3 on
both computers, the connection was easily established

Have great weekend

Alexander
alba (AT) ineonet (DOT) net


"Miguel Salles" <MiguelSalles (AT) discussions (DOT) microsoft.com> сообщил/сообщила в
новостях следующее:
news:7A06DB77-95F1-402B-AFD1-EAC760BC3D9C (AT) microsoft (DOT) com...
Quote:
The Domain stuff can always be a issue, however, maybe you should look the
connection string on the wks. Also, verify that the user you're using on
wks
is part of the (local) "OLAP Administrators Group" on your W2k3.
Good luck

"Alexander" wrote:

SQL Server 2000+ Analysis Server - both on the same W2k3 Server
SQL Server and Windows Authentication - I defined user name and password
to
connect to SQL Server and it works fine (the user is member of SysAdmin
Role)

But when i try to connect my workstation to Analysis Server (or even
register it) within Analysis Manager I get the only message:

Unable to connect to the registry on the server (SERVERNAME) or you are
not
a member of the OLAP Administration group on this server

May be the error occurs because my workstation is member of domain while
W2k3 Server isn't?

Alexander
alba (AT) ineonet (DOT) net






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.