SharePoint 2013 Dashboard Designer can't connect to Sql Analysis Services 2012

Advertisement

  When i  tried to connect Sql Analysis Service , i con't able to get Database. The database drop down remained empty as shown in fig below.


SharePoint 2013 Dashboard Designer was written for Sql Server 2008 R2  Analysis Services clients, so we have to install ADOMD version10 for client support.


After install ADOMD, just perform an IISRESET. Now it will work . Hope this helps!








Advertisements
SHARE

Lakshmi Tulasi Jasti

  • Image
  • Image
  • Image
  • Image
  • Image
    Blogger Comment
    Facebook Comment

5 comments:

  1. Verify permissions: even you are Administrator in Dashboard side, you have to be authorized in SQL Server side and be part of the group who has access to the Cube in SSAS side !... (by default this not allowed... change it manually in this area...) Hope this help... Otto

    ReplyDelete
  2. Hi Othman,

    Thanks for the suggestion..

    ReplyDelete
  3. After installing ADOMD, Dashboard Designer does not run any more! Authentication error occured!

    ReplyDelete
  4. Hi Othman,

    Please revert with step bye step.

    ReplyDelete
  5. I just added the Analysis Services server name: no list of db appears.
    In the Data Source Settings section I then clicked "Per-user Identity", which makes a lot of sense as we have cube based security.
    The list of databases now appears.

    ReplyDelete