• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Mindy Curnutt and Associates

  • Services
  • About
  • Blog
Home » Using Powershell to set Roles & Features required for MDS

May 4, 2016 By Mindy Curnutt

Using Powershell to set Roles & Features required for MDS

This is my 3rd go-around installing MDS on SQL Server. I’ve been playing with it on each of the new SQL 2016 RC builds. Today I’m once again standing it up. Hey, practice makes perfect!

One of the first things that needs to happen in order to get MDS up and running is that the Roles & Features for the server need to be in the right state. Today I was playing with Powershell some (long story…but it involves an orphaned storage group in Azure), so I was already in a Powershell kind of mood. I then found a handy script, which allows you to use Powershell to “presto-chango” get the Roles & Features just right.

From: https://msdn.microsoft.com/en-us/library/ee633744.aspx

I was a little bit awkward pulling it off, but got it done. Wow, that was WAY easier than opening up the Roles and Features area of Windows! no more iterating through all of it, trying to make sure I didn’t miss anything.

Capture

But then, trying to run the Master Data Services Configuraiton Manager I still got one more warning about it needing the feature for Dynamic Web Compression in IIS to be enabled. **sigh**  So — I went back into powershell and added that feature:

compression

After that, everything was good as gold.  As you can see, in the Master Data Services Configuration Manager I had green checkbox on Prerequisites. Now I can move forward!

checkbox

Here’s the entire consolidated Powershell batch for you to copy/paste and run in your environment:

Install-WindowsFeature Web-Mgmt-Console, AS-NET-Framework, Web-Asp-Net, Web-Asp-Net45, Web-Default-Doc, Web-Dir-Browsing, Web-Http-Errors, Web-Static-Content, Web-Http-Logging, Web-Request-Monitor, Web-Stat-Compression, Web-Filtering, Web-Windows-Auth, NET-Framework-Core, WAS-Process-Model, WAS-NET-Environment, WAS-Config-APIs

Install-WindowsFeature Web-App-Dev, NET-Framework-45-Features -IncludeAllSubFeature –Restart

Install-WindowsFeature Web-Dyn-Compression

Mindy Curnutt
Mindy Curnutt

Mindy Curnutt is a five time Microsoft Data Platform MVP with over 20 years of experience working with Database Solutions. She specializes in Performance Tuning and Architecture. She speaks regularly across North America at Local User Groups, SQL Saturdays and Conferences.

Filed Under: MDS, Powershell, What I Learned Today Tagged With: command line scripting language, master customer record, master data services, mds, microsoft powershell, sql

Primary Sidebar

Categories

  • Awards
  • Azure
  • MDS
  • Power BI
  • Powershell
  • Spatial Data
  • SQL
  • What I Learned Today

Archives

  • December 2018
  • November 2018
  • September 2018
  • June 2018
  • May 2017
  • April 2017
  • December 2016
  • November 2016
  • September 2016
  • May 2016
  • April 2016

Recent Comments

  • Twitter Campaign/Brand Management In Power BI – Curated SQL on Power BI, Twitter and the Old Settlers Music Festival

Recent Posts

  • Live! 360 Speaker
  • BOOK PUBLICATION: SQL Server 2017 Administration Inside Out
  • Power BI Class on October 11 – 2018
  • My Article at IT Pro Today – Azure Cosmos DB vs. SQL Server
  • Restoring a SQL Backup from Azure Blob Storage

Footer

Resources Pages

Volunteer Activity
Books and Presentations
Spatial Data Resources
Learning Resources
Speaking Engagements

Privacy Policy

Site Map

Join My Newsletter

Subscribe to my mailing list

* indicates required



Copyright Mindy Curnutt© 2022