SharePoint Day to Day

Windows Server 2016: Fails to Ping Localhost Issue: ping localhost fails (ipv6 message were seen). Solution: Our system administrator ran Microsoft Fix to give preference to IPv4 over IPv6 https://support.microsoft.com/en-ca/help/929852/guidance-for-configuring-ipv6-in-windows-for-advanced-users SQL Server 2017: Fail to Open Configuration Manager Issue: Cannot connect to WMI provider Solution:  http://tritoneco.com/2014/05/15/fix-sql-configuration-manager-cannot-connect-to-wmi-provider The following command must be run as Administrator (140 is for SQL Server 2017): C:\Program Files (x86)\Microsoft SQL Server\140\Shared> mofcomp sqlmgmproviderxpsp2up.mof SharePoint 2016: Unable to Upload Multiple Documents Issue: When directly working on SP 2016 Server, no response when clicking on "Upload files using Windows Explorer instead" Solution: 1. Try to upload files on a client computer where WebClient service is available 2. If working on the SP Server, ple...

1. Setup of the Development Environment I mainly followed  Configure an environment to run your provider-hosted high trust apps in SharePoint 2013 , the best tutorial for beginners! Domains SharePoint Server: ssrpdap03 App domain (IIS site): ssrpdap03apps.com Test app site: myapp.ssrpdap03apps.com   DNS Primary Zone: ssrpdap03 (no need to set as it's already in corporate's DNS server) Primary Zone: ssrpdap03apps.com Host A record: Name=empty, IP=127.0.0.1 Alias CName record: Name=*, FQDN=ssrpdap03apps.com Preferred DNS Server for IPv4: 127.0.0.1 (no need to set 8.8.8.8.8 as Forwarders as corporate has default DNS Servers setting in Root Hints) Create SharePoint website https://ssrpdap03 Use Publishing site template Neither Developer site template nor side loading feature were necessarily installed Certificates https://ssrpdap03 I used C:\Users\wj\AppData\Local\Programs\Fiddler\makecert.exe makecert -n "C...

Provider Hosted Configure an environment to run your provider-hosted high trust apps in SharePoint 2013 http://www.appzinside.com/2015/03/13/configure-an-environment-to-run-your-provider-hosted-high-trust-apps-in-sharepoint-2013/ Creating SharePoint Add-ins that use high-trust authorization https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/creating-sharepoint-add-ins-that-use-high-trust-authorization#RootAuthorities Apps in SharePoint https://blog.trigent.com/apps-in-sharepoint/   SharePoint2016 On Prem -SPFx HelloWorld App deployed to App Catalog but not appearing under "Apps You Can Add" #331 https://github.com/SharePoint/sp-dev-fx-webparts/issues/331 Dive into Sharepoint Caca   http://spcaca.blogspot.com/2013/10/create-on-premise-high-trust-provider.html  How to Create Host Named Site Collections in SharePoint 2013? http://www.sharepointdiary.com/2014/06/create-host-named-site-collections-in-sharepoint-2013.html Set up an on...

Net Core: Reset EF Migrations to a clean State: https://stackoverflow.com/questions/43687433/update-database-command-is-not-working-in-asp-net-core-entity-framework-6-beca https://weblog.west-wind.com/posts/2016/jan/13/resetting-entity-framework-migrations-to-a-clean-slate Removing and Resetting Migrations The idea of this process is basically this: The database and the EF schema are up to date and just the way you want it, so we are going to remove the existing migrations and create a new initial migration. In summary, the steps to do this are: Remove the _MigrationHistory table from the Database Remove the individual migration files in your project's Migrations folder Enable-Migrations  in Package Manager Console Add-migration Initial  in PMC Comment out the code inside of the Up method in the Initial Migration Update-database  in PMC (does nothing but creates Migration Entry) Remove comments in the Initial method You've now essentially re...

We wish to use Single Sign On  to pass Windows Authentication through our Intranet site called LibPrograms. Firstly, we need enable Windows Authentication in IIS. In   IIS / Sites / LibPrograms / Authentication set as follows: Anonymous Authentication: disabled Windows Authentication: Enabled Secondly, add LibPrograms site to Local Intranet: IE 11 - Internet Option / Security / Local Intranet / Sites / Check Automatically detect intranet work / Advanced / Manually add this site to Local Intranet - Check Custom Level for Local Intranet: scroll down to the bottom, in User Authentication section, make sure Automatic logon only in Intranet zone is selected. Note: there is no such settings in IE Edge - so called "modern" browsers. Chrome Settings / Advanced /Search "proxy" / click Open proxy settings / this is the same one settings as in IE 11