PS2007 - OLAP Cube - Analysis Services 2005

T

TroyS

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.
 
C

Chet

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.
 
T

TroyS

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

Chet

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top