Search code examples
sql-serverssasssms

SSAS DB not visible in Management Studio but can be seen in Excel

There is a SQL 2012 Analysis Server with some cubes.

When I connect to it using Excel 2013 (DATA menu > From Other Sources > From Analysis Services), I can see the DB names in the dropdown.

But when I connect to it with SQL Server Management Studio 2012 (with Analysis Service Client installed, I've used it against other Analysis Servers successfully), I can connect to the Analysis Server, but cannot see any DB - the Databases folder is empty.

Did I miss anything? Is it possible that it's intentionally configured to be so?

Solution

  • SSMS is a administration tool. You will only see databases in there to which you have admin access. So if you are not a server admin or are not in a role in any of the databases which has admin rights - you will not see any databases in the object explorer.