Analysis Services Data Source error

Question

I keep getting this error when I'm trying to create connection to Analysis Services Data Source. Can someone please help? 'Either the user,' XXXX\user1', does not have access to the 'AdventureWorks2012' database, or the database does not exist.
268433-errorcapture.png

Answer 1

Hi @Rediet Abebe ,
You need to consider permission issues, such as adding a user group to the analysis server as a server role.

• Open SQL Server Management Studio. In the Connect to Server window, connect to the instance of SQL Server Analysis Services that you are using.
• In Microsoft SQL Server Management Studio, in Object Explorer, right-click your SQL Server Analysis Services instance name, and then click Properties.
• On the Analysis Services Properties page, in the Select a page pane, click Security. NT Users and Groups that are members of the server role will appear in a list.
• Click Add. In the Select Users or Groups page, go to the Enter the object names to select field and enter the name of the group you are adding to the server role. Click Check Name to verify that the account exists.
• Click OK.

Or grant read access to the user group the specific cube: Grant users access to cubes.
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.