Setting up instances of SQL server for tabular and multidimensional models

Question

Setting up instances of SQL server for tabular and multidimensional models

Viewing 6 posts - 1 through 7 (of 7 total)

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

happycat59 One Orange Chip Points: 29451 More actions · Answer 1

If you need to use both SSAS Tabular and SSAS Multi dimensional, you will need to install 2 separate instances of SSAS (one for each). So, yes, you will need to run the installation twice.

For SQL Server and SSIS, you only need to do one install (you can choose whether you want to do this as part of the first or second SSAS installation).

quentin.harris Ten Centuries Points: 1004 More actions · Answer 2

Hi,

Thanks @HappyCat59

So would i do two installs in total then?

In one i would put as default ie localhost (SSIS, Queries and SSAS tabular) and the other a named instance (SSAS multidimensional).

So during the installation i tick SSAS during both installs, but is there a selection where i tick tabular in one and multidimensional in the other?

One further question..

I need the sample databases set up on my local machine and to be able to do cube and data model build on my local machine as currently there is no resource for me to do this in our development environment. Are there any selections during install i need to be aware of to ensure this please?

So far the install instructions i have seen where by watching the following:

Many thanks in advance.

Q

happycat59 One Orange Chip Points: 29451 More actions · Answer 3

Yes - 2 installations as you state.

Microsoft sample database are separate downloads from http://msftdbprodsamples.codeplex.com/

To develop, you need to install the latest version of SQL Server Data Tools (SSDT). Head on over to the Microsoft download site for that.

If you have existing SSAS database (or from the Codeplex samples) installed, SSDT can import them for you and you can edit/change them as you need

quentin.harris Ten Centuries Points: 1004 More actions · Answer 4

Thanks.

I thought SSDT came with the developer edition, but if not i will download separately. I know that i need Visual Studio 2015 (at least) to go with the 2016 developer edition. Not sure if that is an additional requirement?

Q

frederico_fonseca SSCoach Points: 16279 More actions · Answer 5

SSDT will install with a visual studio shell - no need to get a full version of visual studio just for this.

quentin.harris Ten Centuries Points: 1004 More actions · Answer 6

quentin.harris

Ten Centuries

Points: 1004

August 12, 2016 at 12:53 am

#1895162

Thanks