MDS as a hub - licensing RRS feed

  • Question

  • If MDS is used as a central data hub, can I have the SQL Server Enterprise edition server on the top and have the rest of the servers only licensed with Standard Edition, or must all the servers where MDS is managing the data be licensed with Enterprise Edition?
    Thursday, December 12, 2013 9:42 AM


  • MDS can be installed all on one server. The rest of the repositories could be anything you want not even SQL as long as you have some middleware to ETL data between the 2.  MDS user portion is nothing more then a website hosted through IIS, and all users can access it without having any SQL server installation just like they do any other website (through browser). Then this site is pointed at the actual SQL install on the main SQL box. Excel-add in works through a service/proxy also being server up by the MDS website.  You could have the site on the other server separate from the main database server, in that case I think its the same license to install MDS portion (the website portion) on the other server. There is only 1 SQL server. Unless of course you are doing a farm... 

    The hub is the SQL database, what's around is the website for MDS (for user interface) and other providers and consumers that can be anything and do not have to be databases even, could be some program that is supplying or consuming data.

    Thursday, December 12, 2013 2:03 PM