CODEWITHSUNDEEP
sql-serverssas
Artie Ladie
Artie Ladie

Reputation: 521

Restore Instance of Analysis Service

I downloaded

  1. adventure-works-multidimensional-model-full-database-backup.zip

  2. adventure-works-tabular-model-1200-full-database-backup.zip

from GitHub

I would like to restore this in SQL Management Studio Analysis Services, but to do this, I need to create an instance

According to Microsoft I installed

  1. MS SQL Server Management Studio
  2. MS SQL Server Data Tools

How do I create Analysis Service Instance to log into so I can restore adventure-works-tabular-model-1200-full-database-backup > Adventure Works Internet Sales Tabular Sample Database > Adventure Works Internet Sales Database.abf

enter image description here

Upvotes: 0

Views: 393

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89091

You need to download and install SQL Server Developer Edition. Here's the Download Page and the direct download link.

Then run the installer to install an Analysis Services Tabular instance on your dev machine. You can run the installer again to also create an Analysis Services Multi-Dimensional instance, if you need that too.

Upvotes: 1

Related Questions