OLAP Administrators issue

Hi,

I moved my AS 2000 olap database to new hardware also new OS WS 2003 32 bit to 64 bit.

I added domain/loging ID of sql server/job server to "OLAP Administrators" user group

which runs the DTS package to process cubes. This was fine in my old server OS WS 2003 32 bit.

But in new server WS 2003 64 bit cube process failed because job server was not able to connect to AS server.

I had to add job server's domain\login ID to "Administrators" user group in new server and then I was able to process the cube.

I don't want to give administrator access to job server to my olap server is this some thing I can do or missing?

Thank you - Ashok

Here is some information for you from http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

Take a look at the Administrator Security section there.

In general, DSO that client application like Analysis Manager, or DTS task based upon tries couple of things.

One, it remotely accesses registry on server machine and reads RemoteRepositoryConnectionString http://support.microsoft.com/kb/330244

Then it uses it to open AS2000 repository.

Try and see at what point DSO running under user account with fewer privileges fails to acces information it needs.

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

OLAP administrators group.?

hi all..

i have a problem about sql server analysis. i try to connect sql server for OLAP but i can't. sql server analysis give this error "unable to connect to the registry on the server or you are not members of OLAP administrator groups on this server" i use Windows Xp Pro and Sql Server Developer Edition. how can i solve this problem..

Please provide more details? Same machine for Analysis Manager and Analysis Services or different machines? Service Pack 3 or greater on both machines if different machines?

OLAP administrators group.?

hi all..

i have a problem about sql server analysis. i try to connect sql server for OLAP but i can't. sql server analysis give this error "unable to connect to the registry on the server or you are not members of OLAP administrator groups on this server" i use Windows Xp Pro and Sql Server Developer Edition. how can i solve this problem..

Please provide more details? Same machine for Analysis Manager and Analysis Services or different machines? Service Pack 3 or greater on both machines if different machines?

OLAP Administrators group in Analysis server

I'm trying to register server in my Analysis Manager. Help says that you should be a member of OLAP Administrators group . Plz tell me where is this group and how can I add members in this group.
Thanks a lot
SandyYou will find this group on the computer with analysis server running on, you can view members and edit the group via windows - administrative tools- computer management-users and user groups|||thanks a lot friend...I was about to lose my hopes...Thanks a lot...I have already done the same.|||Hi There...I did whatever you said...but when I try to register server I'm getting this new error...
"error: '\\server_name\MSOLAPRepository$\msmdrep.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."

Could you plz tell me what can be the problem and what could be the solution for the same.
Thanks in Advance
Regards
Sandy|||I have never come across this problem, so this is only guess, the problem could be that when you are registering a remote server, you don't have a permission to access msmdrep repository file which is by default located in Program Files\Microsoft Analysis Services\Bin directory on the server computer, I would try to check whether the file exists and whether you have a permission to access it|||I have put myslef in the OLAP Admin group along with "Everyone", "Administrators" and I still get the following error message: Unable to connect to the registry on the server
(server name) or you are not a memeber of the OLAP
administrators on this server."
I am running this on my local machine and am not trying to connect with another server. I am running sql server 2000. Any ideas?

Landon|||Sandy - I think I came across that problem and it's what mojza is saying. Are you trying to get to the Analysis Manager remotely? If so, try logging into the machine where AM is running.

prdbrat - Your problem sounds like the registry for AS was migrated to SQL Server. If so, make sure you are able to access the OLAP Registry on the SQL Server. I think I had to add my ID to our SQL server before this error went away.|||I know! I know! I had the same problem. Go to your registry under olap server --> delete the remoterepositoryconnectionstring which is a regz_binary.

Than try your analysis manager again to register. It worked for me.