search
Japanese Chinese Nederlands Espanol Italiano Deutsch Francais Twitter Rss Feeds
Office GroupsView
Excel
Excel Charting
Excel Crashesgpfs
Excel Misc
Excel Newusers
Excel Programming
Excel Setup
Excel Worksheet Functions
Office Communicator
Office Developer Automation
Office Developer Com Add_Ins
Office Developer Visual Basica
Office Misc
Office Setup
Office Templates Misc
Officeupdate
Onenote
Outlook
Outlook Bcm
Outlook Calendaring
Outlook Contacts
Outlook General
Outlook Installation
Outlook Program_Addins
Outlook Program_Forms
Outlook Program_Visual Basica
Outlookexpress General
Project
Project Developer
Project Server
Visio
Visio Developer
Visio General
Word Application Errors
Word Customization Menustoolbars
Word Drawing Graphics
Word Mailmerge Fields
Word Pagelayout
Word Programming
Word Tables
Word Visual Basica Beginners
Word Visual Basica Customization
Word Visual Basica General
Works Win

Group SummariesView
.NET Framework
Access
BizTalk
Certifications
CRM
DDK
Exchange Server
FoxPro
French
French .NET
Games
German
German .NET
Graphic Design
IIS
Internet
ISA Server
Italian
Italian .NET
Maps
MCIS
Miscellaneous
Mobile Application Development
Money
MSN
Networking
Office
Ops Mgr
Publisher
Security
SharePoint
Small Business
Spanish
Spanish .NET
SQL Server
Systems Management Server
Transaction Server
Virtual PC / Virtual Server
Visual Studio
Win32
Windows 2000
Windows 2003 Server
Windows 7
Windows Live
Windows Media
Windows Update
Windows Vista
Windows XP
 

View All Microsoft Project Server Posts  Ask A New Question 

PS2007 - OLAP Cube - Analysis Services 2005 - Troy

Friday, June 06, 2008 4:06 PM

We are following the process as outlined below where we've created an
Analysis Database in SQL Server 2005 and are trying to add a new login called
'OLAP Administrators'

However, following the procedure as noted below, we can't add OLAP
Administrators and it does not show in the server's Users and Groups.

What are we missing to get OLAP Administrators added ?
We've installed Analysis Services 2005 on the database server and are
working from there...



Option 2: Create the repository by creating a SQL Server 2005 database
If you do not have an OLAP repository file that has been migrated to a SQL
Server database, it is possible to create one in SQL Server to use in SQL
Server 2005 Analysis Services. The following procedures creates the
repository database and runs a SQL script to create the required database
schema.
Create the Repository database in SQL Server 2005
1.	Open SQL Server Management Studio, for Server Type, select the Database
Engine, and click Connect.
2.	In Microsoft SQL Server Management Studio, right-click the Databases
folder and click New Database.
3.	On the New Database page, for Database Name type Analysis Services
Repository. Click OK.
4.	In the Object Explorer list, expand the Security folder. Right-click
Logins and then click New Login.
5.	In the Login Name section, click Search.
6.	In the Select Users or Groups page, click Object Type.
7.	In the Object Type page, select Groups, and then click OK.
8.	In the Select Users or Groups page, go to the Enter the object name to
select box and enter the OLAP Administrators group for this computer. Click
OK.
9.	In the Select a page list, click User Mappings. In the Users mapped to
this login list, select Analysis Services Repository.
reply
 

PS2007 - OLAP Cube - Analysis Services 2005 - chet_dodg

Friday, June 06, 2008 5:31 PM

Troy:
For PS2007 / SQL2005 the OLAP Administrators group name is:
SQLServer2005MSOLAPUser$ENG-PROJECTSQL2$MSSQLSERVER

Try selecting that group.

Previous versions used OLAP Administrators.

Hope this helps.
--
Chet Dodge, Program Manager
Inter-Tel
reply

Thanks, we'll give that a shot. - Troy

Friday, June 06, 2008 5:36 PM

Thanks, we will give that a shot.
Do you think the PS2007 documentation is incorrect then?
and were you successfully in using the account you provided?
reply

PS2007 - OLAP Cube - Analysis Services 2005 - chet_dodg

Monday, June 09, 2008 2:17 PM

Troy:
The account worked for me. I initially tried what you did as well. Same
result you had. Once I made the change (which I found in the Gary Chefetz and
Dale Howard book "Implementing and Administering PS 2007") it worked.
--
Chet Dodge, Program Manager
Inter-Tel
reply
 
 

Previous Microsoft Project Server conversation.