Unable to install Application Server Role, Web Server (IIS) Role SharePoint 2016

When installing on new win 2016 VM i got this error: Unable to install Application Server Role, Web Server (IIS) Role. Most solutions install features using Win Server ISO installation and Powershell. But you can enable to download features/components from windows update.

When we run the SharePoint 2016 pre-requisites installer in order to prepare our machine to install SharePoint 2016 product installation on Windows Server 2016, the installer fails due to the error shown in the screen below:

“The tool was unable to install Application Server Role, Web Server (IIS) Role”

 

The error occurred due to the reason that your operating system Windows Server 2016 do not allow applications to connect to the internet straight away to download files necessary for installation.

In order to fix this error, some steps need to be taken as described below:

  1. Open an MMC console.
  2. Add the Group Policy Object snap-in.
  3. The following screen will open.
  4. In Local Computer Policy go to Computer Configuration –> Administrative Templates and select “System”.
  5. Scroll down the list in the System settings and find “Specify settings for optional component installation and component repair”. Double-click the settings, a screen as displayed below will appear.
  6. Select Enabled in the top left corner and select “Contact Windows Update directly to download repair content instead of Windows Server Update Services (WSUS)”.
  7. Click OK and close the MMC console.
  8. Run the pre-requisite installer again and this time it will not give errors on a server role installation.

note: also turn off internet explorer enhanced security configuration for admins…

 

Microsoft Flow SharePoint Send Email By Due Date

Scope: Get Calendar Due Date and Send Email if due dates within 5, 30 or 90 days from current date.

Initially I used SPD and created 3 workflows. Here’s a screenshot of the 5 Day SPD workflow using pause actions. Didn’t work like I wanted it. Problem is that if the “due date” changed at any time, the workflow will keep the original Due Date.

 

Solution: Microsoft Flow

So Here’s the Microsoft Flow Version that I can schedule a recurrence and check the list every day and get the correct due date. This is only a rough draft of the Flow.

Set Recurrence. I set it to daily.

 

I check to see if DueDate is Null to reduce any Flow errors. You could make it required too. First I check 5 Day condition then 30 and 90.

All conditions are similar, I just use adddays function to change the logic. Final version of Flow will have a different email messages about the notice.

Only limitation is that Flow will only loop thru 500 items. Dynamic OData filters for SharePoint Connectors are not enabled yet. I could add filters after the Get Items too. but initial Get items is limited to 500. Flow is still new and getting new features added. Will continue testing and trying out advanced conditions.

BI Resources and Links

Here’s a list of blogs that has helped me configure Power Pivot for SharePoint 2010 and 2013

SharePoint 2013 Kereberos setup http://blog.blksthl.com/2012/09/26/the-first-kerberos-guide-for-sharepoint-2013-technicians/#step4

Installing 2013 BI features : http://blogs.msdn.com/b/querysimon/archive/2012/11/26/installing-the-bi-features-of-sharepoint-2013.aspx

Installing 2010 BI features: http://blog.cloudshare.com/2012/05/22/step-by-step-guide-to-installing-sharepoint-with-sql-2012-powerpivot-powerview-and-reporting-services/

another 2010 BI blog: http://blogs.msdn.com/b/karang/archive/2012/04/13/step-by-step-guide-of-installing-power-view-with-powerpivot-2012.aspx

Notes: things get tricky in a multi server farm. the SQL install will have all the features needed for SharePoint. For SharePoint 2013 there is a spPowerPivot.msi you can use on the WFEs instead of the SQL server install.

Application Pool Password Recovery

I had to figure out an App Pool password. Depending on your version of IIS you can extract passwords. You just need to login remotely and have local admin access.

For IIS 6

Download resource kit from http://www.microsoft.com/en-us/download/details.aspx?id=17275

And run Metabase Explorer, then just browse to your App Pool. Change your view settings to show Secure Data.

For IIS 7+

run this powershell command with your app pool name.

&$env:windir\system32\inetsrv\appcmd.exe list apppool “Application Pool Name” /text:ProcessModel.Password

 

 

 

Custom Actions for SharePoint designer workflows

I found a great set of custom actions called iLoveSharePoint. One of the actions is an Execute SQL action. Very handy for sending data from a list to SQL. I’ve started sending data to SQL so i can use Reporting Services to create dashboards to report item history. You can download the solution from codeplex: http://ilovesharepoint.codeplex.com/

 

 

1 2 3