dbTalk Databases Forums  

Cannot connect to Analysis Services server

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


Discuss Cannot connect to Analysis Services server in the microsoft.public.sqlserver.olap forum.



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

Default Cannot connect to Analysis Services server - 12-21-2004 , 06:23 AM






Hi!
I installed Analysis Services yesterday and was building some test cubes
with no problems, today, when I tried opening my cubes, it appears that my
Analysis Server (FJKILKEN-MOBL) is not available – giving the error message
of :


"Unable to connect to the registry on the server FJKILKEN-MOBL, or you are
not a member of the OLAP Administrators group on this server"



I have shut-down/restarted, and then checked that all appropriate services
(SQL server, OLAP server etc…) are running – which they are – any idea on
what the issue could be?

Thanks a lot



Reply With Quote
  #2  
Old   
Andrej Hudoklin
 
Posts: n/a

Default Re: Cannot connect to Analysis Services server - 12-21-2004 , 06:42 AM






Did you check also if your account is member of OLAP Administrators group on
the computer that is running Analysis Services?


HTH
Andrej


"Fergal Kilkenny" <Fergal Kilkenny (AT) discussions (DOT) microsoft.com> wrote in
message news:9F6BAB70-66DD-43EA-AAF8-B2243B6982E8 (AT) microsoft (DOT) com...
Quote:
Hi!
I installed Analysis Services yesterday and was building some test cubes
with no problems, today, when I tried opening my cubes, it appears that my
Analysis Server (FJKILKEN-MOBL) is not available - giving the error
message
of :


"Unable to connect to the registry on the server FJKILKEN-MOBL, or you are
not a member of the OLAP Administrators group on this server"



I have shut-down/restarted, and then checked that all appropriate services
(SQL server, OLAP server etc.) are running - which they are - any idea on
what the issue could be?

Thanks a lot





Reply With Quote
  #3  
Old   
Fergal Kilkenny
 
Posts: n/a

Default RE: Cannot connect to Analysis Services server - 12-21-2004 , 07:13 AM



yes, checked that alright, and I am the only member of the OLAP Admins -
strange that I didn't have an issue yesterday and I do today - it's nothing
to do with the IP Address of my machine do you think? Here at Intel I think
we are dynamically allocated IP addresees when we login.....

"Fergal Kilkenny" wrote:

Quote:
Hi!
I installed Analysis Services yesterday and was building some test cubes
with no problems, today, when I tried opening my cubes, it appears that my
Analysis Server (FJKILKEN-MOBL) is not available – giving the error message
of :


"Unable to connect to the registry on the server FJKILKEN-MOBL, or you are
not a member of the OLAP Administrators group on this server"



I have shut-down/restarted, and then checked that all appropriate services
(SQL server, OLAP server etc…) are running – which they are – any idea on
what the issue could be?

Thanks a lot



Reply With Quote
  #4  
Old   
Andrej Hudoklin
 
Posts: n/a

Default Re: Cannot connect to Analysis Services server - 12-21-2004 , 08:27 AM



OK.

Check then your repository connection string.
It work throguh share directory by default.

Check that!

HTH,
Andrej



"Fergal Kilkenny" <FergalKilkenny (AT) discussions (DOT) microsoft.com> wrote in
message news:5730600C-CB13-4AC0-8918-474EE0F40A3A (AT) microsoft (DOT) com...
Quote:
yes, checked that alright, and I am the only member of the OLAP Admins -
strange that I didn't have an issue yesterday and I do today - it's
nothing
to do with the IP Address of my machine do you think? Here at Intel I
think
we are dynamically allocated IP addresees when we login.....

"Fergal Kilkenny" wrote:

Hi!
I installed Analysis Services yesterday and was building some test cubes
with no problems, today, when I tried opening my cubes, it appears that
my
Analysis Server (FJKILKEN-MOBL) is not available - giving the error
message
of :


"Unable to connect to the registry on the server FJKILKEN-MOBL, or you
are
not a member of the OLAP Administrators group on this server"



I have shut-down/restarted, and then checked that all appropriate
services
(SQL server, OLAP server etc.) are running - which they are - any idea on
what the issue could be?

Thanks a lot





Reply With Quote
  #5  
Old   
Fergal Kilkenny
 
Posts: n/a

Default Re: Cannot connect to Analysis Services server - 12-21-2004 , 09:05 AM



thanks for the reply - how exactly do I check the connection string?

"Andrej Hudoklin" wrote:

Quote:
OK.

Check then your repository connection string.
It work throguh share directory by default.

Check that!

HTH,
Andrej



"Fergal Kilkenny" <FergalKilkenny (AT) discussions (DOT) microsoft.com> wrote in
message news:5730600C-CB13-4AC0-8918-474EE0F40A3A (AT) microsoft (DOT) com...
yes, checked that alright, and I am the only member of the OLAP Admins -
strange that I didn't have an issue yesterday and I do today - it's
nothing
to do with the IP Address of my machine do you think? Here at Intel I
think
we are dynamically allocated IP addresees when we login.....

"Fergal Kilkenny" wrote:

Hi!
I installed Analysis Services yesterday and was building some test cubes
with no problems, today, when I tried opening my cubes, it appears that
my
Analysis Server (FJKILKEN-MOBL) is not available - giving the error
message
of :


"Unable to connect to the registry on the server FJKILKEN-MOBL, or you
are
not a member of the OLAP Administrators group on this server"



I have shut-down/restarted, and then checked that all appropriate
services
(SQL server, OLAP server etc.) are running - which they are - any idea on
what the issue could be?

Thanks a lot






Reply With Quote
  #6  
Old   
Andrej Hudoklin
 
Posts: n/a

Default Re: Cannot connect to Analysis Services server - 12-21-2004 , 09:10 AM




rigth click on registred server in Analysis Services Manager -> edit
repository connection string



HTH
Andrej




"Fergal Kilkenny" <FergalKilkenny (AT) discussions (DOT) microsoft.com> wrote in
message newsB11D7E7-323B-47A6-9888-79CFA0D45EE1 (AT) microsoft (DOT) com...
Quote:
thanks for the reply - how exactly do I check the connection string?

"Andrej Hudoklin" wrote:

OK.

Check then your repository connection string.
It work throguh share directory by default.

Check that!

HTH,
Andrej



"Fergal Kilkenny" <FergalKilkenny (AT) discussions (DOT) microsoft.com> wrote in
message news:5730600C-CB13-4AC0-8918-474EE0F40A3A (AT) microsoft (DOT) com...
yes, checked that alright, and I am the only member of the OLAP
Admins -
strange that I didn't have an issue yesterday and I do today - it's
nothing
to do with the IP Address of my machine do you think? Here at Intel I
think
we are dynamically allocated IP addresees when we login.....

"Fergal Kilkenny" wrote:

Hi!
I installed Analysis Services yesterday and was building some test
cubes
with no problems, today, when I tried opening my cubes, it appears
that
my
Analysis Server (FJKILKEN-MOBL) is not available - giving the error
message
of :


"Unable to connect to the registry on the server FJKILKEN-MOBL, or you
are
not a member of the OLAP Administrators group on this server"



I have shut-down/restarted, and then checked that all appropriate
services
(SQL server, OLAP server etc.) are running - which they are - any idea
on
what the issue could be?

Thanks a lot








Reply With Quote
  #7  
Old   
Fergal Kilkenny
 
Posts: n/a

Default Re: Cannot connect to Analysis Services server - 12-21-2004 , 10:09 AM



I got this from the Meta Data tab, as the Properties option is grayed-out
when I right-click:

Provider=Microsoft.Jet.OLEDB.4.0
Data Source=C:\Program Files\Microsoft Analysis Services\Bin\msmdrep.mdb

"Andrej Hudoklin" wrote:

Quote:
rigth click on registred server in Analysis Services Manager -> edit
repository connection string



HTH
Andrej




"Fergal Kilkenny" <FergalKilkenny (AT) discussions (DOT) microsoft.com> wrote in
message newsB11D7E7-323B-47A6-9888-79CFA0D45EE1 (AT) microsoft (DOT) com...
thanks for the reply - how exactly do I check the connection string?

"Andrej Hudoklin" wrote:

OK.

Check then your repository connection string.
It work throguh share directory by default.

Check that!

HTH,
Andrej



"Fergal Kilkenny" <FergalKilkenny (AT) discussions (DOT) microsoft.com> wrote in
message news:5730600C-CB13-4AC0-8918-474EE0F40A3A (AT) microsoft (DOT) com...
yes, checked that alright, and I am the only member of the OLAP
Admins -
strange that I didn't have an issue yesterday and I do today - it's
nothing
to do with the IP Address of my machine do you think? Here at Intel I
think
we are dynamically allocated IP addresees when we login.....

"Fergal Kilkenny" wrote:

Hi!
I installed Analysis Services yesterday and was building some test
cubes
with no problems, today, when I tried opening my cubes, it appears
that
my
Analysis Server (FJKILKEN-MOBL) is not available - giving the error
message
of :


"Unable to connect to the registry on the server FJKILKEN-MOBL, or you
are
not a member of the OLAP Administrators group on this server"



I have shut-down/restarted, and then checked that all appropriate
services
(SQL server, OLAP server etc.) are running - which they are - any idea
on
what the issue could be?

Thanks a lot









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.