Error message installing Workflow Manager and Service Bus

I needed a Workflow Manager Installation for my SharePoint 2016 farm and I used the Web Installer to do all the Installation work for me following this guide:

https://gallery.technet.microsoft.com/SharePoint-2016-Workflow-acd5ba2a

When the Installation finished I configured the Installation Manager with the wizard and got the following error message during the configuration:

System.Management.Automation.CmdletInvocationException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

The reason for this error in my case was the language of the SQL Server. Mine is installed in German and that means there is no Group called BUILTIN\Administrators. Instead I have a group called VORDEFINIERT\Administratoren. So I changed the values in the wizard for the admin groups to their german name but still no luck: The wizard only accepts BUILTIN\Administrators and not VORDEFINIERT\Administratoren. So I changed my admin Groups to domain Groups like CONTOSO\Domänen-Admins and that worked and I was able to accomplish the Installation.

ResourceUnhealthyException when moving mailbox back to on premise Exchange

The last couple of days I did some test with Exchange Online and Exchange on premise hybrid environments. I connected my on premise Exchange environment with Exchange Online and moved a mailbox to the cloud (Onboarding). The move succeeded and the mailbox was reachable in the cloud. After this  I wanted to move the mailbox back to my on premise environment (Offboarding) and created a new move request. This time the move failed and I got the following error in the move log:

Error = Transient error ResourceUnhealthyException has occurred

The reason for this error is that the search index of my on premise databases was corrupt. Before Exchange starts the move of the mailbox it check if the destination mailbox is healthy. If this is not the case, because the search index is corrupt, the move will fail with error message above. I followed the instructions in the following articles to recreate the search index of my content databases:

https://practical365.com/exchange-server/fix-failed-database-content-index-exchange-2013/

https://blog.brankovucinec.com/2015/10/02/fix-the-exchange-2013-content-catalog-index/

The whole process of index recreation took some hours to complete. Afterwards I created a new move request and this time it worked and the mailbox was moved back to the Exchange on premise organization.

The response status code is ‘Unauthorized’ using Connect-PNPOnline

We use the SharePoint Patterns and Practices framework in a project to provide SharePoint Site Collections for SharePoint Online. For a few days now, when I log on to SharePoint Online with the PowerShell cmdlet Connect-PnPOnline, I have received the following error message:

Cannot contact web site 'https://customer-admin.sharepoint.com/' or the web site does not support SharePoint Online credentials. The response status code is 'Unauthorized'. The response headers are 'X-SharePointHealthScore=0, X-MS
DAVEXT_Error=917656; Access+denied.+Before+opening+files+in+this+location%2c+you+must+first+browse+to+the+web+site+and+select+the+option+to+login+automatically., SPRequestGuid=ac6c229e-80d9-4000-83e5-3a2938f84c4b, request-id=ac6c229e-80d9-4000-83e5-3a2938f84
c4b, MS-CV=niJsrNmAAECD5TopOPhMSw.0, Strict-Transport-Security=max-age=31536000, X-FRAME-OPTIONS=SAMEORIGIN, SPRequestDuration=187, SPIisLatency=1, MicrosoftSharePointTeamServices=16.0.0.6927, X-Content-Type-Options=nosniff, X-MS-InvokeApp=1; RequireReadOnly
, X-MSEdge-Ref=Ref A: 4A35F4682A1449D1967ECE00FC378207 Ref B: AMSEDGE1019 Ref C: 2017-10-13T07:23:37Z, Content-Length=0, Content-Type=text/plain; charset=utf-8, Date=Fri, 13 Oct 2017 07:23:36 GMT, P3P=CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD T
AI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI", X-Powered-By=ASP.NET'.

The response contains the following text:

Access denied. Before opening files in this location you must first browse to the web site and select the option to login automatically.

Although my credentials are correct, and I can easily log on to the SharePoint Online Admin page with these credentials, they are not accepted by the cmdlet. A similar problem is listed in the Github Issue List for the PNP Framework:

https://github.com/SharePoint/PnP-PowerShell/issues/1126

In this case, the solution was to replace the CSOM libraries included in the PNP framework with the most current ones provided by Nuget. I have not tested this approach.

Another solution I’ve found is to set the parameter LegacyAuthProtocolsEnabled to $True in the SharePoint Online Tenant, but that didn’t work for me:

https://blog.areflyen.no/2017/06/18/problem-with-connecting-to-sharepoint-online-in-office-365-with-powershell-sharepoint-designer-and-other-3-party-tools/

In my case, I used the -UseWebLogin: $true parameter to log on to the Connect-PNPOnline cmdlet. The cmdlet call then looks like this:

Connect-PnPOnline -Url $Url -UseWebLogin: $true

This causes the cmdlet to start a window with Internet Explorer and loads the SharePoint Online login page, asks for my data, and then logs me on. That worked for me.

 

Change Windows product key from command line and activate it

Sometimes, when I want to change the product key on Windows Server 2016, I can’t do it because nothing happens when I click the link in the activation Settings. If this happens I use slmgr.vbs from the command line to Change the key and activate it online.

Use the following command to change the product key:

slmgr.vbs /ipk ABCDE-FGHIJ-KLMNO-PQRST-UVWXY

And this command to activate it online:

slmgr.vbs /ato

The following site has a lot of examples on how to use slmgr.vbs:

https://www.howtogeek.com/245445/how-to-use-slmgr-to-change-remove-or-extend-your-windows-license/

Activate common Desktop Icons on Windows 10 and Server 2016

I still like to have the icons for ‘Network’ and ‘This PC’ on my Desktop on Windows. In Windows 10 and Server 2016, this setting is not so easy to find. It can be accessed via Settings -> Personalization -> Designs -> Themes -> Desktop Icon Settings.

Another way is to execute the following command:

rundll32.exe shell32.dll, Control_RunDLL desk.cpl,, 0

The setting can also be found via the desktop search by typing in the term “Common”.