dbTalk Databases Forums  

oops! OLAP Admin group deleted!!!

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


Discuss oops! OLAP Admin group deleted!!! in the microsoft.public.sqlserver.olap forum.



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

Default oops! OLAP Admin group deleted!!! - 12-21-2004 , 08:35 AM






Not sure if it was deleted or just didn't migrate properly when we changed
servers but the OLAP Administrators group is missing from the Windows Groups.
Any ideas how can I recreate the group? Thanks!

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

Default RE: oops! OLAP Admin group deleted!!! - 12-21-2004 , 09:51 AM






did you try :
Control Panel, Administrative tools, Computer Management, Right-click on
groups, select New Gropup, and add a group called OLAP Administrators - then
add your users

Fergal

"J Jetson" wrote:

Quote:
Not sure if it was deleted or just didn't migrate properly when we changed
servers but the OLAP Administrators group is missing from the Windows Groups.
Any ideas how can I recreate the group? Thanks!

Reply With Quote
  #3  
Old   
J Jetson
 
Posts: n/a

Default RE: oops! OLAP Admin group deleted!!! - 12-21-2004 , 12:03 PM



What are the permissions that the group should have? Is it enough that the
new group is called "OLAP Administrators" or does it needs to have
permissions granted to it? Thanks

"Fergal Kilkenny" wrote:

Quote:
did you try :
Control Panel, Administrative tools, Computer Management, Right-click on
groups, select New Gropup, and add a group called OLAP Administrators - then
add your users

Fergal

"J Jetson" wrote:

Not sure if it was deleted or just didn't migrate properly when we changed
servers but the OLAP Administrators group is missing from the Windows Groups.
Any ideas how can I recreate the group? Thanks!

Reply With Quote
  #4  
Old   
Jasper Smith
 
Posts: n/a

Default Re: oops! OLAP Admin group deleted!!! - 12-21-2004 , 05:16 PM



On my PC it has Full Control on HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP
Server and also the folder Program Files\Microsoft Analysis Services\Data

--
HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"J Jetson" <JJetson (AT) discussions (DOT) microsoft.com> wrote

Quote:
What are the permissions that the group should have? Is it enough that the
new group is called "OLAP Administrators" or does it needs to have
permissions granted to it? Thanks

"Fergal Kilkenny" wrote:

did you try :
Control Panel, Administrative tools, Computer Management, Right-click on
groups, select New Gropup, and add a group called OLAP Administrators -
then
add your users

Fergal

"J Jetson" wrote:

Not sure if it was deleted or just didn't migrate properly when we
changed
servers but the OLAP Administrators group is missing from the Windows
Groups.
Any ideas how can I recreate the group? Thanks!



Reply With Quote
  #5  
Old   
Paul Ibison
 
Posts: n/a

Default RE: oops! OLAP Admin group deleted!!! - 12-22-2004 , 10:55 AM



As well as Jasper's point, my group has rights to the
following folders:
D:\Analysis Services\data
C:\Program Files\Microsoft Analysis Services\Bin
As far as I recall, OLAP administrative privileges are
nothing more than these rights.
Rgds,
Paul Ibison

Reply With Quote
  #6  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: oops! OLAP Admin group deleted!!! - 12-22-2004 , 06:46 PM



OLAP Administrators group should also have access to repository - depends
whether it is in msmdrep.mdb on the MsOLAPRepository$ share - both needs to
have access, or migrated to SQL Server.
I recommend reinstalling AS and restoring your database to make sure you
stay on the supported path though.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Paul Ibison" <Paul.Ibison (AT) Pygmalion (DOT) Com> wrote

Quote:
As well as Jasper's point, my group has rights to the
following folders:
D:\Analysis Services\data
C:\Program Files\Microsoft Analysis Services\Bin
As far as I recall, OLAP administrative privileges are
nothing more than these rights.
Rgds,
Paul Ibison



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.