SQL BI

My Experience - Troubleshooting SQL BI Stack

Tabular: Cant see Databases in Management Studio

Tabular: Cant see Databases in Management Studio

  • Comments 1

 

Background

You have a Role which got only Read Permission for Tabular Database with users who can only query Databases which means they can use any client tool and should be able to query Tabular Databases from any tool which they prefer like SSMS, SSRS, PPS, Excel, etc.

Roles and Permission shown in Figure 1 and Figure 2

Figure 1: Role Permission

image

Figure 2: Test User member of Role which got Read Permission

image

Issue

When users from Read Only Role are trying to connect SQL Management Studio they are not able to see Databases on which they have Read Permission but if they do the same thing in an Instance of MOLAP they are able the to see the Databases on left side under Databases tree of Management Studio as shown in Figure 3, if you notice databases are not displayed for Test_Karan user.

 

Figure 3: Databases are not Displayed

image

Assessment: From TechNet Article - Roles (SSAS Tabular) we understand its an expected behavior

image

So what’s an option you have when you want to query Tabular Database with DAX or MDX and Databases are not getting displayed in Management, answer is simple – just click on MDX Query in the Management Studio as show in Figure 4

Figure 4: Click MDX and you will find that you will be able to Query Database on which you have Read Permission as shown in Figure 5

image

Figure 5: Though you are not able to see all databases but you can change the database which you need to query.

image

 

Conclusion

In MOLAP when you had Read Permission you were able to see those Databases in Management Studio but in Tabular Instance you cant see any more its by deign, in this post I have tried to show something simple which we generally tend to miss.

Comments
  • Thanks Karan

    It is very helpful resource. I wan unable to connect a cube and struggling for a week for which I have a read access. I followed the steps in this blog post and easily able to connect and query cubes.

    Keep posting!

Page 1 of 1 (1 items)
Leave a Comment
  • Please add 1 and 1 and type the answer here:
  • Post