Feb 20
[ASPUG] Adelaide SharePoint User Group February 2017 Newsletter

Greetings and Salutations,

Due to lots of events taking place locally and internationally as well as other demands, we have decided not to have a user group meeting this month and will resume our first 2017 meeting on the 21st of March. Early Bird Registration is open here.

We do apologies for the late notice but we look forward to seeing you next month. Stay tuned!

-Adelaide SharePoint User Group Team

Microsoft Ignite

Microsoft Ignite has wrapped up for this year at the gold coast.

You can view all the Microsoft Ignite 2017 sessions and more at https://msftignite.com.au/

Recommended Watching:

More information can be found at https://msftignite.com.au/

Office 365 Developer Podcasts

A great resource is the Office 365 Developer Podcast show presented by Richard diZerega and Andrew Coates.

A particular episode of note is Episode 117 with Jeremy Thake on Microsoft Teams and extensibility - https://blogs.office.com/2017/02/09/episode-117-jeremy-thake-microsoft-teams-extensibility-office-365-developer-podcast/

In episode 117 of the Office 365 Developer Podcast, Richard diZerega and Andrew Coates are joined by Jeremy Thake to discuss Microsoft Teams and extensibility.

You can check out the site and the podcast at https://dev.office.com/podcasts

Visual Studio Dev Essentials

Visual Studio Dev Essentials is a new, free program that brings together everything developers need to create applications on any device or operating system including Visual Studio Community and Visual Studio Code, and the free tier of Visual Studio Team Services. Dev Essentials adds priority forum support, training services from Pluralsight, Wintellect, and Xamarin, and—something that many have asked for—monthly credits to use in Azure. You can find all the details on https://www.visualstudio.com/products/free-developer-offers-vs


User Group Sponsors

The Adelaide SharePoint User Group would like to welcome two new well known and trusted identifies as official sponsors of the Adelaide SharePoint User Group, JetBrains and Telerik and thank them frothier support of the user group!


Check out our website at http://www.aspug.org.au/

We also have a number of Social Media platforms:

List Management

Feel free to forward these emails to others who may be interested in the Adelaide SharePoint User Group. If they wish to receive emails directly about the Adelaide SharePoint User Group, they should send a message to me at the address below.

If you would like to include meeting details in your works internal newsletter, please also feel free to do so.

We are in the process of setting up a facility for companies who which to include meeting details can be notified by an automated system. If you would like to participate, please contact Daniel Brown (daniel@danielbrown.id.au).


Please let us know if you have any feedback on how we can improve the user group. Also, if you would like to present to the group on your experiences with SharePoint, just let us know. I can be contacted at daniel@danielbrown.id.au or by visiting http://www.aspug.org.au.

Jan 25
I’m Back!

After 2-3 weeks of internet service degradation and a further 2 weeks of no service at all… Telstra finally fixed the fault…. It took them to replace over 200 pairs and over 250 meters of cable under the street to finally get mine (and about 100 other people) service restored!

Now lets sit back and watch the internet get hammered as updates and downloads fly off the handle for the next 24 hours :D

More to come!



Nov 30
Microsoft Word Viewer… no more!

As announced today on the Office Sustained Engineering team blog….

The Microsoft Word Viewer is being retired in November, 2017.  At that time, the Viewer will no longer be available for download and will no longer receive security updates. 

Microsoft recommends using these applications to view Word files:

  • On Windows 10 PCs, download the free Word Mobile application from the Windows Store.
  • On iOS devices, download the free Word for iOS application from the Apple Store.
  • On Android devices, download the free Word for Android application from the Google Play store.
  • Try Office 365 for free for 1 month, which gives you access to the full versions of Word, Excel, PowerPoint, Outlook and more and can be installed on up to 5 PCs or Macs, plus up to 5 tablets and 5 phones.
  • On Windows 7 or Windows 8/8.1 PCs, upload the file to OneDrive and view it for free using Word Online.

Original Post at https://blogs.technet.microsoft.com/office_sustained_engineering/2016/11/29/word-viewer-to-be-retired-in-november-2017/

Nov 23
SQL Server 2014 Service Pack 2 Installation on Windows Server 2012 R2 Core

Just a quick post to say.. if like me and you run SQL Server on Windows Server Core.. the way of getting SP2 installed is via the following command:

>SQLServer2014SP2-KB3171021-x64-ENU.exe /qs /IAcceptSQLServerLicenseTerms /Allinstances

This will show up the progress bar and nothing else, then all installed!

For more details about installing updates from a command prompt (soon to be powershell prompt!) see:

Have a great day!

Nov 19
Office Online Server November Release

As posted on the Office Blog…. Office Online Server November release is now… released!

The first significant update to Office Online Server that includes:

  • Performance improvements to co-authoring in Word Online.
  • Support for embedded Power View sheets in Excel Online.
  • Improvements when working with tables in Word Online and PowerPoint Online, including better drag-and-drop support.
  • Support for showing spelling errors inline in the PowerPoint editor.
  • Improved picture resizing in Word Online.
  • Copy and paste improvements in PowerPoint Online.
  • Support for shapes in Excel Online viewer.
  • Significant improvements for users that rely on assistive technologies—HTML markup updated to more fully support W3C accessibility standards.

Please note: That to obtain this update you need to log in to the Volume License Serving Center and you must UNINSTALL the previous version and reinstall the new one.

Also… looks like Office Online Server is moving to a 4 month release cycle, with updates being provided every 4 months.

Full details can be found here - https://blogs.office.com/2016/11/18/office-online-server-november-release/

Nov 18
SQL Server Reporting Services and SharePoint - Simplifying our SharePoint integration story

Some interesting news from the SQL Server team on their blog..

Moving forward, SQL Server vNext will only offer one type of installation, Native Mode… Integrated mode is no more.

image“Starting with SQL Server v.Next, there’ll be only one installation mode for Reporting Services: “Native” mode. It’s a standalone BI solution you can deploy, whether or not you have SharePoint, and it offers the full set of Reporting Services features: a modern web portal, paginated reports, mobile reports, KPIs, and more. With the Technical Preview of Power BI reports in Reporting Services, you can view and interact with Power BI reports in your web browser, and in time, we aim to support web-based viewing of Excel workbooks in Native mode as well.”

For full details, check out the Reporting Services Team blog at:

Reporting Services has been around along time and over the past 10 years, its usage ive seen has just been going up and up.

It comes as no surprise the support for on-premise integration with a cloud-first product (SharePoint) is discontinued, while support for on-premises reports is maintained.

Reporting Services 365 has to be floating around somewhere!

Nov 18
Windows Server 2016 Standard (Core) and SharePoint 2016–Part 3–AppFabric

Still working my way thru getting the prerequisites installed… with mostly success!

Getting closer.. Tho I need a restart :D


One thing I did find out (forgot to get a screenshot) is to install WindowsServerAppFabricSetup_x64.exe, it actually requires Windows Update Service to be running. easy enough… Net start wuauserv


and… its already running…. hmmm…

Next up… lets try the /i switch which is the silent install option

“WindowsServerAppFabricSetup_x64.exe /i”

Wait a couple of minuets and try and run WindowsServerAppFabricSetup_x64.exe again. it extracts as usual, and them I'm presented with this:


GUI for AppFabric 1.1 for Windows Server Setup Wizard!

Running through the Wizard, all features are installed. Excellent!


so… after a restart and a couple of preprequsist installs…. I try setup again….



Ouch! That's going to hurt. SharePoint setup wants me to uninstall appfabric and have the prereq tool istall and configure it.

Also, this native client business… swear i installed that.

Nov 17
Windows Server 2016 Standard (Core) and SharePoint 2016–Part 2– Windows Identity Problems!

Windows Server 2016 Standard (which is CORE!) and SharePoint 2016… the quest continues…

Continuing on from my previous blog post on this matter…

Windows Identity Framework is causing me grief still…

I thought it may be that .NET 3.5

is not installed, so…  I tried installing I :) via:

C:\> dism /online /enable-feature /featurename:NetFx3 /All /Source:D:\sources\sxs /LimitAccess

It installed fine :)

Also running Get-WindowsFeature works a treat!


So looking at Get-WindowsFeature, I can see that the web server role and .NET 4.6 are installed, along with all the other bits a pieces for a web server with .NET.

So, Next I tried to download the prerequisites and install them manually

Windows Identity Extensions gave me this:


Windows Identify Framework gave me this:


Great! Hmmm.

OK, so next step it to get what pre-prerequisites I can get installed… installed…. to do this, and not via the UI.. I’ve grabbed a Dan Holme’s SharePoint 2016 Offline prerequisites downloader PowerShell script from here and have set it running on the VM.


And…. My VM WITH a GUI.. is chugging along….



The quest continues!

Nov 16
SharePoint 2016 begins on Windows Server 2016 Standard “Core”





There was an error during installation.



Reviewing the error log revels that PowerShell had a problem running a command….

XPS Viewer, Web Management Console (Both are GUI things.. this is on core remember) and the Windows Identify Foundation (eep.. this is going to cause problems) are not available in Windows Server 2016 as expected for SharePoint 2016.




OK, So lets try this scripted with a console!

To install the pre-requisites, launch powershell and type/copy/paste the below

Add-WindowsFeature NET-HTTP-Activation,NET-Non-HTTP-Activ,NET-WCF-Pipe-Activation45,NET-WCF-HTTP-Activation45,Web-Server,Web-WebServer,Web-Common-Http,Web-Static-Content,Web-Default-Doc,Web-Dir-Browsing,Web-Http-Errors,Web-App-Dev,Web-Asp-Net,Web-Asp-Net45,Web-Net-Ext,Web-Net-Ext45,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Health,Web-Http-Logging,Web-Log-Libraries,Web-Request-Monitor,Web-Http-Tracing,Web-Security,Web-Basic-Auth,Web-Windows-Auth,Web-Filtering,Web-Digest-Auth,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Mgmt-Tools,Web-Mgmt-Compat,Web-Metabase,WAS,WAS-Process-Model,WAS-NET-Environment,WAS-Config-APIs,Web-Lgcy-Scripting -verbose

After a little tweaking….


OK, well that takes care of that, lets try it again





And just for giggles… setup (notice the top one now… Identify Extensions)



More work is needed! Stay Tuned

Nov 16
TLS 1.1 and TLS 1.2 security protocols support in SharePoint

Microsoft has added official support for the TLS 1.1 and TLS 1.2 security protocols in SharePoint 2013 https://technet.microsoft.com/library/mt757340.aspx and SharePoint 2010 https://technet.microsoft.com/li…/mt757339(v=office.14).aspx

1 - 10Next
​​ ​​
About this blog
Yes, this is actually my picture. I have gotten around to updating this section. It's good to know that someone is reading every last word though. Thanks!
 Archon Gnosis
 Adelaide SharePoint User Group
 LinkedIn - Adelaide SharePoint User Group