no longer seeing Analysis Services databases

When I connect (with windows authentication) to Analysis Services server I no longer see 3 existing databases. Say , this username is domain/abc

Analysis Services are running as "Logon as" NT SERVICE\MSSQLServerOLAPService service

What should I check, this user used to be able to see all databases ? Where can I add permissions to Analysis Servises db?

February 20th, 2015 12:30pm

I 've found the root cause. This user was no longer a member of the Role created for those cubes. I have no clue why/what caused this, maybe network admin did some clean up and changed something for domain/abc ..

I've added domain/abc as a member of a Role created for those cubes, saved, deployed , processed and it worked.


  • Marked as answer by BrBa 17 hours 1 minutes ago
  • Edited by BrBa 16 hours 57 minutes ago
Free Windows Admin Tool Kit Click here and download it now
February 20th, 2015 1:32pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics