Hi ,

I would appreciate if someone could provide some clarity around this issue:

I have installed SQL on Clusters and in the Application server I have
Project server. To instanciate an OLAP CUBE from Project Server, I require
SSAS which was installed on the SQL Box. However, I noticed that on the SQL
machine there wasnt any groups called "SQLSERVER2005$OLAPUSERS$<Macihne
Name>$<Instance Name> " Existing.

I created that manually but then when creating a new login within SQL, I get

"Error: Create failed for Login <Local System
Name>\SQLServer2005MSOLAPUser$<MachineName>$<Insta nceName>'

and In Additional Infomration, I received:

Windows NT user or Group "the above group" not found, Check the name
again....?Microsoft sQL Server Error 15401).

1. So can I have SSAS in an Cluster ?
2. How to get the Local Group for MSOLAPUser$ associated with the SQL Login ?

Kindly advice ..

Best Regards,
Gokul Rajan