Geeks With Blogs

Mike H. - Another Geek In Need... WebLog

Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server

 

The devil is always in the details J

 

The following I wanted to share because this individual sorted through this error and his resolution may help someone else. I am posting a summary of our correspondence.

 

PROBLEM:

BizTalk Deployment Failing – Error: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server

 

 

============================================================

 

From: Shalabh

To: Mike

Date: 8.31.05 2006 hours EST

Subject: Biztalk deployment failing.

 

Message…

Hello Mike,

 

I have a 3box setup -

1. BizTalk 2004 (installed DSO and Client Tool for AS) 2. SQL Server 2000 (SP3a and SQL2000-KB810185-8.00.0878-ENU.exe)

3. Analysis Server 2000 (SP3a - sql2kasp3.exe)

 

My BizTalk 2004 configuration is continually failing with message - "Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server"

 

Can you think of anything? Nobody answered to my newsgroup query.

 

Appreciate your time.

 

 

============================================================

 

 

From: Mike

To: Shalabh

Date: 8.31.05 2035 hours EST

Subject: Biztalk deployment failing.

 

Message…

Initially, based on what you have conveyed, the BTS Administrator's Group needs access to the OLAP server's OLAP Admins group.

 

Usually, the same service account is used for BTS and OLAP - so you do not run into this problem.

 

Check the service account / user account that is running both the BTS Admins group and the OLAP group.

 

============================================================

 

From: Shalabh

To: Mike

Date: 8.31.05 2146 hours EST

Subject: Biztalk deployment failing.

 

Message…

Okay.

I changed the Analysis Service to run under the credentials of domain\BtsService.

I added the 'domain\BtsAdmin' account and 'domain\Biztalk Server Administrators' as members of OLAP Administrators group on each box.

 

I still get the same result.

 

I also changed the Analysis service to run under domain\BtsAdmin but still the same error.

 

Any more ideas??

 

============================================================

 

From: Mike

To: Shalabh

Date: 8.31.05 2204 hours EST

Subject: Biztalk deployment failing.

 

Message…

There can obviously be a number of issues.

 

Have you tried walking through the stand-alone deployment that on my bog? It's pretty straight-forward, and works perfectly?

 

============================================================

 

From: Shalabh

To: Mike

Date: 9.01.05 1300 hours EST

Subject: Biztalk deployment failing.

 

Message…

Answer to your questions:

<machinename> is the box where OLAP or Analysis Service is installed. I get my actual machine name in the error message.

 

I tried running OLAP under local service and still the same result. There are no services running on the BTS box that I can see.

 

I did check the event viewer and there were no error messages or warnings on both boxes.

 

I did see this problem listed on msdn and applied the patch they suggested at the bottom of the following page:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/troubleshoo

ting/htm/ebiz_depl_install_fdjh.asp

 

Problem: You may encounter the error "Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server" or the BAM cube DTS fails on execution.

 

Resolution: Install the following software: (download from

http://go.microsoft.com/fwlink/?LinkId=22840)

 

============================================================

 

From: Mike

To: Shalabh

Date: 9.01.05 1410 hours EST

Subject: Biztalk deployment failing.

 

Message…

Open Component Services... Expand Component Services-->Computers, and right-click on My Computer.

 

Select the MSDTC tab, then in the lower-left, Security Configuration.

 

Ensure that

 

NetWork DTC Access - checked

Network Administration - checked

Network Transactions - checked

Network Clients - checked

Transaction Internet Protocol - unchecked XA Transactions - Checked

 

And it should be running as the NETWORK SERVICE account.

?

 

============================================================

 

 

From: Shalabh

To: Mike

Date: 9.01.05 1421 hours EST

Subject: Biztalk deployment failing.

 

Message…

On BTS Server, the Network Clients was not checked and I checked it.

On OLAP box, MSDTC was not enabled. I enabled it and ensured the option below were checked and rebooted the box.

 

Still the same result.

 

============================================================

 

 

From: Shalabh

To: Mike

Date: 9.01.05 1506 hours EST

Subject: Biztalk deployment failing.

 

Message…

Found out...need to install sp3a on the BTS box as well.

 

Thank you so very much.

 

============================================================

 

 

 

SOLUTION

As you can see, the problem was solved by installing the installing Service Pack 3a on the BTS box. On this box was the SQL Server/OLAP client and DSO (Decision Support Object) tools, but without the SP3a patch, the error was persistent.

 

I want to thank Shalabh for permission to post this information – and I am glad another problem has been solved.

Posted on Friday, September 2, 2005 7:10 AM BizTalk , SQL Server | Back to top


Comments on this post: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this serve?
Left by anny on May 22, 2006 5:31 PM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Anny, I'm not sure what your inquiry is.

If you're asking what (machineName) represents above - simply the name of the host machine.
Left by MikeH on May 22, 2006 5:34 PM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
well, I did the install about sp3a, but the error still appear. I unnable connect to registry on the server(machineName),....
Left by anny on May 22, 2006 5:39 PM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Anny, are you working on the same machine - or is SQL remote?

If SQL is remote - make sure the account you are using has permissions on the remote SQL box. If you're executing as NETWORK SERVICE or SYSTEM - you will fail.

Let me know...
Left by MikeH on May 22, 2006 5:48 PM

# PROBLEM about install teh analysis service
Requesting Gravatar...
i having teh same error message as Shalabh,
but after i dowload eth sp3a and install it in my machine, the problem still the same.
any ideal about it?
Left by anny on May 22, 2006 5:51 PM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
no, I am working one local server machine right now.
Left by anny on May 22, 2006 5:52 PM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
MS sql enterprise namgerinstall is fine, but just the analysis service can not connct to the registry on the server.

maybe install the spa3 has some special thing that i donot know?
Left by anny on May 22, 2006 5:57 PM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Anny, can you share the following?

OS you are installing on
What you are installing (BTS, SQL, OLAP, etc.)
The service (user) account you are using to execute these services (or are they all running on the SYSTEM account?)
Finally, does the user account, if you are using one, belong to the local Admins group? I'm asking because adding it to admin and testing again would eliminate that as the issue (basically eliminating permissions).
Left by MikeH on May 22, 2006 6:01 PM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
I am working on the window server 2003, and i download the spa3 and install the files in the this server machine, are there any problem with installing the spa3 In server machin?
any one can help?
Left by anny on May 22, 2006 6:04 PM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Anny, there are no issues with SP3a that I am aware of.

The original posting for this error message had to do with running BTS and OLAP on 1 machine, and SQL Server remote to that machine. The developer did not think to install SP3a for OLAP on the BTS host.

It sounds like you may be running into something different, and I suspect it's more permissions related.
Left by MikeH on May 22, 2006 6:10 PM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
I've been having a similar problem and have found it to be a firewall issue. Found it by turning on auditing (control pnl\admin\local security settings\local policies\audit policy - 'tick' the 'failure' box). Retry your actions (I was attempting to register a server in AS). On failure, check the security log in event viewer. I had numerous firewall errors. The firewall option in Control was marked as 'off' (I'm behind a corporate firewall) however, there is a 'windows firewall' service still running. I stopped this service and AS is now operating fine. Hope that helps someone...
Left by Darren on May 25, 2006 9:25 AM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Darren, I hadn't even thought of that.

Thank you very much for the post.
Left by MikeH on May 25, 2006 10:01 AM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Soko, BTS is the BizTalk Server host machine. This posting had to do with a setup that involved BTS on its own host, and SQL Server and Analysis Services (SA) on a remote machine/host.

The developer had to install the SP3a (Service Pack 3a for SQL Server) on the BTS host as well to get around this issue.

Hope this is helpful...
Left by MikeH on Jun 06, 2006 12:19 PM

# Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
I don't have biztalk server, i've installed AS in XP.....
please help me what i have to do
Left by Soko on Jun 06, 2006 12:40 PM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Soko, I apologize for not getting back to you sooner.

I have been posting about BizTalk and other .Net development efforts.

I do not know what you want to accomplish or what you are trying to do with Analysis Services.

If you are trying to install the Admin component on XP, that should not be an issue.

Can you be more specific about what you are trying to do?

Thanks...
Left by MikeH on Jun 06, 2006 8:12 PM

# Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
I have been doing MIS course and we have to work on MDX sample application and have to pass some queries to retrieve data from cube and all.

Before starting MDX sample application, I supposed to register the server in analysis manager, that time this error coming and I am not able to work on it

This is my problem, please let me know the solution
Left by Soko on Jun 14, 2006 2:34 AM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Soko,

Please bear with me as I try to understand the environment.

It sounds like you have an OLAP server - remote from your development workstation, is this correct?

If that is correct, you have OLAP XP on your workstation, and now you are trying to register the remote server, is this correct?

In the above example, and if you are working with SQL 2000 AS, you will need the same service packs on each, the server and the workstation.

So, does the remote server have SP3a installed, as does your workstation? Or does the server have a different service pack?

If the above senario is not correct - and you have installed everything on 1 local workstation, then it sounds more like something was installed as Administrator, while something else is trying to be configured with less permissions than necessary to configure, if that makes sense?

Without actually seeing an error dump or something, I really can't guess at what might be going on.

You should have additional information in the Application event log, and possible SQL dumps as well that would be helpful to identify what is happening before the error is thrown.
Left by MikeH on Jun 16, 2006 9:09 AM

# Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Hi mike
I have installed Sql2000 Analysis Services.
I wanted to work on MDX sample applications which is there in analysis services.
For that first i need to register my server in analysis manager which is there in analysis services. when i try to register this error is coming.
server/client is in local workstation, i don't have any connection with remote server.
i have downloaded sp3a from microsoft.com.I've installed it and when i register my server in analysis manager, it got registered, but there in no any database....
even i opened MDX sample applications, it also connected but there is no database, no cubes. i'm getting the following error:
UNABLE TO OPEN CELLSET.UNABLE TO OPEN
CUBE .... (eg: sales)

This is what happening, plz solve it out
Left by Soko on Jun 24, 2006 3:12 AM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Hi Soko. Okay, it sounds like you have successfully configured Analysis Services - great.

But it also sounds like you do not have any sample database out there to work against. The sample walk-through you are doing... Which database does it reference? Is it an AdventureWorks sample that should be restored to the AS instance?

Let me know.
Left by MikeH on Jun 24, 2006 9:26 AM

# Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Hi Mike,
mine is sql2000 AS,so I need foodmart2000 database
Left by Soko on Jun 27, 2006 2:09 AM

# Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Hi Mike I'm so happy, my analysis services working perfect.
what i did is, i removed both sql2000 server and analysis services. then i installed only analysis services 2000, after that i installed SP3a - sql2kasp3.exe.now its working perfect....

i think we can't install sql server with analysis services together,either of them takes the database. anyway its working

Thanks a lot
Left by Soko on Jun 27, 2006 4:05 AM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Hi Soko - very glad to hear it is working now. I know you have been very frustrated.

Sometimes configuring AS and SQL on the same host - obviously - can be frustrating - but they do both work on the same host.

When you move into SQL 2005 and all the new stuff - you will find the configuration a lot easier. It's learning all the new toys they give you that'll be frustrating at first.

Very glad to hear you got this resolved.
Left by MikeH on Jun 27, 2006 8:23 AM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
hi, can anyone tell me how to register as a member of olap administrator group
Left by sudip on Aug 15, 2006 11:10 AM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Hi Sudip,

When you install OLAP, a security group is created under Local Users and Groups on the machine you install it on. This is the group you would add users to.

HTH's...
Left by MikeH on Aug 15, 2006 11:30 AM

# Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Hi Mike
thanks for your response. could you kindly elaborate it. i am totally new to this. sometimes i am getting connected while other times am not able to do so. i am running the application on windows xp.
thanks in advance.
Left by sudip on Aug 15, 2006 3:39 PM

# Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
In a local system with WINDOWS XP , I installed
MSSQL 2000 (Developed Edition).
All the services are started (SQL Server, Agent and OLAP Services)
during the system startup and I connect to the local Instance
.
When I tried to open the Analysis Manager I found that I can't
connect with the local instance, a message like this raised
"Unable to connect to the registry on the server (MILTOS), or you
are not a member of the OLAP Administrators group on this server"
where MILTOS is the local instance name.
please help me out. what steps should i take now.
thanks in advance


Left by sudip on Aug 15, 2006 4:22 PM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
Hi Sudip,

A friend of mine had a similar issue yesterday, if I understand the issue.

You have a standalone development XP workstation and you have installed SQL and OLAP on that workstation, correct?

Did you install all service packs?

When you are installing on a local box - all components - the error would almost be erroneous, possibly because of a service pack (SP) not being applied. You should not see this error when working locally on a development station.

Alternative, try uninstalling everything, install SQL, install OLAP, install the SP4 for both SQL and OLAP. Do not try to create any databases with OLAP until all SP's are applied.

Let me know.
Left by MikeH on Aug 16, 2006 8:58 AM

# re: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server
Requesting Gravatar...
hi Mike
thanks a lot. i did install all the service packs. and now its working fine.
thanks again.
Left by sudip on Aug 17, 2006 4:49 PM

Your comment:
 (will show your gravatar)


Copyright © Michael J. Hamilton, Sr. | Powered by: GeeksWithBlogs.net