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.
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:
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!
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 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.