Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SSMS - No database shown in Analysis Services

Odpovědět SSMS - No database shown in Analysis Services

  • Wednesday, February 13, 2013 2:14 AM
     
     
    Sign In to Vote
    0

    Hi all,

    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.

    Regards,

     

All Replies

  • Wednesday, February 13, 2013 3:21 AM
     
     Answered
    Sign In to Vote
    1

    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

    http://www.mssqltips.com/sqlservertip/2776/configuring-permissions-for-sql-server-analysis-services/

    Regards,Eshwar.

    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
     
     Answered
    Sign In to Vote
    0

    Hi,

    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

    thanks

    D.nagarjuna

    • Marked As Answer by Mao Zhi Wednesday, March 06, 2013 7:55 AM
    •  
     
  • Wednesday, March 06, 2013 7:56 AM
     
     
    Sign In to Vote
    0

    Thanks for your advice, and I have solved the problem as you say: Run as Administrator.

    Thanks,