Project - PS2007 - OLAP Cube - Analysis Services 2005

Asked By Troy

06-Jun-08 04: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.

06-Jun-08 05: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

06-Jun-08 05: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?

09-Jun-08 02: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