Wednesday, February 13, 2013 2:14 AM
I used SQL Server Management Studio(SSMS) to connect Analysis Services.
The connection is successfully made but there is no database shown in the Database Folder. There is no Assembly shown as well.
In usual, there must be 3 databases and 5 assemblies(ExcelMDX, EXCELINTERNAL, etc)
Hope someone knows this issue and lets me know how to fix it.
Wednesday, February 13, 2013 3:21 AM
This might because you don't have permissions to view the cube.
Are you trying to connect to some other system server? Then you should add yourself to the role of the cube to access a particular cube.
This give different levels of security you can concentrate on creating a role in cube and assigning user to the role
Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.
Monday, March 04, 2013 10:30 AM
please connect to the analysis server as administrator then u will see the all the databases in the analysis folder
such as Run as Administrator of the SSMS
- Marked As Answer by Mao Zhi Wednesday, March 06, 2013 7:55 AM
Wednesday, March 06, 2013 7:56 AM
Thanks for your advice, and I have solved the problem as you say: Run as Administrator.