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