dbTalk Databases Forums  

RE: Cannot open connection to analysis server

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


Discuss RE: Cannot open connection to analysis server in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Wei Zhang [MSFT]
 
Posts: n/a

Default RE: Cannot open connection to analysis server - 10-13-2003 , 04:28 PM






sounds like a security issue assuming you can register the same server
locally.

Are those 2 servers located in a same domain? Your current login to the
remote workstation needs to be a member of the olapadmin group of the olap
server machine.

Thanks

Wei Zhang
Microsoft OLAP PSS
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
  #2  
Old   
pingnetf
 
Posts: n/a

Default Re: Cannot open connection to analysis server - 10-15-2003 , 02:18 AM







Originally posted by Wei Zhang

Quote:
sounds like a security issue assuming you can register the same server

locally.



Are those 2 servers located in a same domain? Your current
login to the

remote workstation needs to be a member of the olapadmin group of
the olap

server machine.



Thanks



Wei Zhang

Microsoft OLAP PSS

This posting is provided "AS IS" with no warranties, and confers no
rights.


Hi,



Thanks for your reply.

I was out of office for a few days, attending MS course 2074a - MS
Analysis Server :-).



Both machines are on the same domain.

We always logon to our workstation using a domain account, both my
account and my colleagues are in the OLAP Administrators group on
both machines.



Sincerely,



Francis.


--
Posted via http://dbforums.com


Reply With Quote
  #3  
Old   
Wei Zhang [MSFT]
 
Posts: n/a

Default RE: Cannot open connection to analysis server - 10-15-2003 , 04:08 PM



Hi, Francis
You can turn on Analysis Service AuditEvents via registry:
Modify the value of HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP
Server\CurrentVersion\AnditEvents to 15 (Dec), the default value is 13
(Dec).

And then reproduce the problem. This time you can see the actual login name
from Application event log. Is it the same account or not?
Thanks
Wei Zhang
Microsoft OLAP PSS
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
  #4  
Old   
Ricardo Sada
 
Posts: n/a

Default Re: Cannot open connection to analysis server - 11-07-2003 , 11:06 AM



Hi,

I'm having this exact same problem. I have two development workstations
running Analysis Services one WinXP Pro the other one Win2K pro.. form
the Win2K pro I can register the server running on XP with no problem..
however the other way around y get the message:

[Cannot open connection to Analysis server "mysever" Error in data
[Possible data corruption] .....

I tried your suggestion and the message in the Application Log only says
exactly this:

User closed connection 2 from

which leaves me clueless ..

Id really appreciate any help

thanks



Wei Zhang [MSFT] wrote:

Quote:
Hi, Francis
You can turn on Analysis Service AuditEvents via registry:
Modify the value of HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP
Server\CurrentVersion\AnditEvents to 15 (Dec), the default value is 13
(Dec).

And then reproduce the problem. This time you can see the actual login name
from Application event log. Is it the same account or not?
Thanks
Wei Zhang
Microsoft OLAP PSS
This posting is provided "AS IS" with no warranties, and confers no rights.



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.