= 2 Node SQL 2008 R2 Failover Cluster on Windows 2008 Enterprise R2 SP1
= 2 instances are installed (default + named)
= Analysis Services is installed and its resource is online on the cluster
Prerequisites to setup Microsoft SharePoint Server 2010 and Microsoft Project Server 2010..
As per Microsoft (http://technet.microsoft.com/en-us/library/ee662108.aspx#section4
> “ Before installing Microsoft SharePoint Server 2010 and Microsoft Project Server 2010, you must first configure Microsoft SQL Server and Analysis Services”...
> “ Configure Analysis Services…..To add the Farm Administrator account to the OLAP users local group: SQLServerMSASUser$<SERVERN
SERVER (SQL Server 2008)”
In our case this local group [SQLServerMSASUser$<SERVER
LSERVER] does not exist on neither node nor the domain!... SQL setup was smooth…services are running, and resources are online.....is there anything changed on SQL2008 R2 related to this group?