New Analysis Services database - NOT

  • I've added SSAS 2014 to an existing instance with no apparent problems - except that I don't see an option to create a New Database on the right-click menu. Restore and Attach are there, but no New Database. I believe I have full admin rights.

    The SSAS instance is to be used by an end-user with the Excel Data Mining Add-in Table Analysis Tool.

    Sorry if I'm missing something obvious - I've managed to avoid SSAS to date.

  • Run SSMS as administrator. R-Click the SSMS Icon and click "Run as Administrator" then connect to SSAS and then try it.... If that works now is the time to add yourself as an Administrator.

  • Many thanks for the response, but that hasn't made any difference.

    One thought - during the install I selected Tabular mode. Should that perhaps have been Multidimensional mode?

    Chloe

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply