Can Different Editions of tools (SSAS, SSRS, SSIS) connect to SQL Server?

  • We're in the process of setting up a pretty comprehensive Data Warehouse solution. Looking at the licensing though it is pretty expensive. The plan currently is to have:

    Active/Passive SQL Cluster with Default instance (12 Cores, Enterprise) 12*$6874 = $82,488.00

    2 SSIS Servers (2 VCPU, Enterprise, ONLY SSIS installed)

    2 SSAS Servers (8 Cores, Enterprise, ONLY SSAS installed) 16*$6,874 = $109,984

    I'm still unsure how the VCPU licensing works, but removing that we're looking at 28 Cores of Enterprise. List price for an Enterprise core is $6874.

    28*$6874 = $192,472 ....and that's not including the hardware cost! :crazy:

    My thought was to just install SSIS and SSAS from the Standard edition of SQL Server (Or even the BI edition), and then do Server + CAL Licensing.

    Active/Passive SQL Cluster with Default instance (12 Cores, Enterprise) 12*$6874 = $82,488.00

    2 SSIS Servers (2 VCPU, STD, ONLY SSIS installed) (2*898= 1796)+((5 CALS each?)2*5*209=$2,090)=$3,886

    2 SSAS Servers (8 Cores STD, ONLY SSAS installed)(2*898= 1796)+((50 CALS each?)2*50*209=$20,900)=$22,696

    Doing this would bring the price down to $82,488+$3,886+$22,696=$109,070 Which is still crazy expensive, but is $80k cheaper than the original solution.

    So, my question is, is this possible, has anyone else done this? What pitfalls should I be conscious of?

  • I answered my own questions.

    Yes you can do this.

    Yes there are restrictions as to the features of the specific SQL Components (SSIS,SSRS,SSAS) by the edition you install.

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

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