SQLServerMSASUser$MachineName$Instanzname not found

Hi..

Our Setup:
= 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

Issue:
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$<SERVERNAME>$MSSQLSERVER (SQL Server 2008)”

In our case this local group [SQLServerMSASUser$<SERVERNAME>$MSSQLSERVER] 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?
AJN-ITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan McCauleyData and Analytics ManagerCommented:
When you're installing SQL Server onto a Failover Cluster, there's a step of the install that asks you for local group mappings for various services (this screenshot shows only the SQL Engine, but you'd also have a box for SSAS and SSRS if you're installing those):

http://dbperf.files.wordpress.com/2010/07/1709_18.jpg

These groups override the local groups you're looking for, and SQL Server uses the domain group membership to determine permissions for these resources, so instead of searching for the local group with that name, you'd want to check the membership of whatever group you specified during installation.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.