Speaking at SharePoint user group Houston USA #SPSHOU

As always, presenting to SharePoint community across the world is a priceless sensation. This time I’ll be talking about SharePoint and OneDrive for SharePoint Houston User Group (H-SPUG) people.

Session-SPSHou

There are two parallel sessions organized for this event and you can find out the full details of HSPUG web site.

http://h-spug.org/

You can register here: https://www.eventbrite.com/e/next-generation-collaboration-with-sharepoint-and-onedrive-tickets-48652812873?aff=erelexpmlt#tickets 

SPSHou

750 Town and Country Blvd #1000, Houston, TX 77024

Advertisements

Microsoft Just Released SharePoint Server 2019 Public Preview

Few hours ago, Microsoft announced the general availability of SharePoint Server 2019 public preview. SharePoint is doubtlessly tops the list when it comes to collaboration and productivity platforms with record breaking popularity across the globe and diverse technical community engaged around this technology. Though the SharePoint online seems to be fascinating with its’ vast improvements, there is still a massive demand for On-Premise server edition which Microsoft can’t simply eliminate, and as a result, here comes the latest release of SharePoint Server edition, SP 2019!.

This release is the public preview which means it should not be used in production environments. Public preview can have limited set of features as the final release is yet being developed by Microsoft.

Key Features:

These are the major highlights of the SharePoint 2019 features list.

  • Modern Sites, Pages, Lists, and Libraries
  • Team News
  • SharePoint Home
  • Communication Sites
  • OneDrive Sync Client
  • Improved hybrid support and scenarios
  • New developer options
  • Improved support for business process with PowerApps and Flow

Compatibility:

  • Operating System: SharePoint Server 2019 requires Windows Server 2016 or 2019
  • SQL Server: SQL Server 2016 or 2017 required

SharePoint Server 2019 is optimized to fit modern usability demands and been influenced by Office365.

Important:

  • Do not use the public preview edition for production
  • There is no clear path on shifting from public preview to the final product so beware on the content you put on public preview setup.
  • Project Server is already bundled to SharePoint 2019 as it was in 2016. No additional binaries required to be installed
  • No SharePoint Foundation edition in 2019 either
  • SharePoint 2019 will be released in the 2nd half of 2018
  • Make use of SharePoint 2019 forum for any technical queries – https://social.technet.microsoft.com/Forums/office/en-US/home?forum=SP2019

Most importantly, let’s have a look at new, deprecated and removed features of SharePoint server 2019.

Removed features (Not available in 2019):

  • Code-Based Sandbox Solutions

Code-based sandbox solutions were deprecated in SharePoint Server 2013 and have now been removed in SharePoint Online. Customers are recommended to explore SharePoint add-ins as an alternative, which are fully supported for both SharePoint on-premises and SharePoint Online.

  • Digest Authentication

Microsoft is deprecating the Digest authentication feature in Internet Information Services (IIS). This authentication mechanism isn’t very popular and there are many alternative authentication mechanisms available with better interoperability.

  • Incoming email automatic mode

Microsoft is deprecating the IIS 6 Management compatibility features in Internet Information Services (IIS). Customers using incoming email are recommended to use advanced mode instead, which allows you to manually manage the IIS SMTP service and drop folder.

  • Multi-Tenancy

The cost and complexity of providing an on-premises alternative has become prohibitive, so we will no longer support multi-tenancy in the SharePoint Server 2019 Public Preview release

  • PowerPivot Gallery and Refresh

Microsoft BI strategy has shifted away from heavy integration to a standalone BI solution, Power BI, to give customers a flexible, optional integration with SharePoint along with standalone capabilities. Both PowerBI.com and Power BI Report Server offer the option to host and view Excel Workbooks with PowerPivot models

  • Visio Services – Silverlight Based Rendering

Visio Services has 2 options for rendering Visio diagrams: Microsoft Silverlight-based and PNG-based. Microsoft Silverlight is a technology that will no longer be supported as of October 12, 2021. Visio Services will only render Visio diagrams using the PNG-based technology.

Deprecated Features (Discontinued investing but remains in SharePoint 2019):

  • Access Services 2010

Will remain supported, but deprecated, for the SharePoint Server 2019 Public Preview release. Customers are recommended to explore Microsoft PowerApps and Flows as potential alternatives to Access Services 2010

  • Access Services 2013

Will remain supported, but deprecated, for the SharePoint Server 2019 Public Preview release. Customers are recommended to explore Microsoft PowerApps and Flows as potential alternatives to Access Services 2013.

  • Aggregated Newsfeed

Feature will be set to read-only in SharePoint Server 2019 Public Preview. For customers who are currently using this feature, we recommend considering options such as Team News, Communication Sites, Yammer and/or Teams.

  • Custom Help

The new SharePoint help system is now rendered in the cloud and will have updated, synchronized content with Office 365.

  • Groove Sync Client

SharePoint Server 2019 Public Preview introduces support for the new OneDrive Sync Client (a.k.a. the Next Generation Sync Client), which provides a more reliable and feature-rich syncing experience

  • InfoPath Services

As announced in the Microsoft 365 blog, InfoPath Services is a deprecated feature and customers are advised to explore alternatives. InfoPath Services will remain supported, but deprecated, for this release.

  • Lists Web Service

The following SOAP endpoints in the Lists web service depend on the Microsoft Sync Framework, which was necessary to support the Groove sync Client: Lists.GetListItemChangesWithKnowledge, Lists.UpdateListItemsWithKnowledge

  • Machine Translations (and Variations)

The Machine Translation Service will remain supported, but deprecated, for the SharePoint Server 2019 Public Preview release.

  • PerformancePoint Services

PerformancePoint Services has a significant dependency on Microsoft Silverlight, which is a technology that will no longer be supported as of October 12, 2021. Customers are recommended to explore Microsoft PowerBI as an alternative

  • SharePoint Designer

There will not be a new SharePoint Designer client shipped with this release. Microsoft will ensure that SharePoint Designer 2013 will work with SharePoint Server 2019 Public Preview for the remainder of the client support lifecycle (2026).

  • Site Mailbox

As announced in the SPO Community Blog, site mailboxes are being deprecated in SPO. Site mailboxes will remain supported, but deprecated. Customers are recommend to explore shared mailboxes as an alternative to site mailboxes.

  • Site Manager

The main functionality of Site Manager is now available in modern file move. Only site collection administrators will have permission to access the Site Manager page and the UI entry points to this page will be removed.

Download Media:

You can download you copy of SharePoint Server 2019 here – https://go.microsoft.com/fwlink/?LinkId=2006095

OneDrive Making a Real Comeback

collab365-watch-my-session

Have you heard about the virtual Collab365 Global Conference 2017 that’s streaming online November 1st – 2nd?

Join me and 120 other speakers from around the world who will be bringing you the very latest content around SharePoint, Office 365, Flow, PowerApps, Azure, OneDrive for Business and of course the increasingly popular Microsoft Teams. The event is produced by the Collab365 Community and is entirely free to attend.

Places are limited to 5000 so be quick and register now.

During the conference I’d love you to watch my session which is called : ‘OneDrive Making a Real Comeback’

OneDrive and OneDrive for business has been vital for collaboration context. Microsoft is making OneDrive better and better everyday with bunch of exciting and useful new features. Let’s discover the latest on OneDrive as its now acts as a more unified product with the latest capabilities announced.​

If you join me, you will learn:

  • Latest of OneDrive
  • OneDrive
  • Unified OneDrive for everyone

Topic(s):

  • OneDrive

Audience :

  • End User
  • IT Manager
  • Power User

Time (in UTC) :

  • Thursday, November 2 2017 7:00 AM

How to attend :

  1. Register here.
  2. At the time listed above go here to watch my session. (you can also add me to your own personal planner from the agenda.
  3. Be ready to take notes!

SharePoint Multitenancy – BCS and Secure Store Service applications are not appeared in the tenant admin portal

When your developers asking for BCS to be configured and If you do not see any links for BCS and Secure Store Service applications under your tenant admin portals, it’s quite normal. That not necessarily mean the Multitenant concept is not supporting BCS or SSS in partitioned mode. When the initial scripts are executed to perform service application creation, these two applications are also provisioned. However the linking is not done.

As per Microsoft:

  • Business Data Connectivity service

Once configured in partition mode, all configuration of the Business Data Connectivity service moves to tenant administration. However the Tenant Administration site template does not include the link to this page, which can be added using the customization technique in the Extending the Tenant Administration site template section

  • Secure Store service

Once configured in partition mode, the generation of encryption keys remains a farm level configuration performed either via Central Administration or Windows PowerShell. The remainder of the Secure Store service configuration moves to tenant administration. However the Tenant Administration site template does not include the link to this page, which can be added using the customization technique in the Extending the Tenant Administration site template section.

Spencer did a wonderful job with his detailed explanation to Multitenancy http://www.harbar.net/articles/sp2013mt.aspx. Thanks to this great series of article, I was able to setup a comprehensive farm for one of the government agency in Asia which has over 30 tenants. Nevertheless, it doesn’t seems to cover this particular problem.

There is a solution in CodePlex for this, but I didn’t attempt to try as it involves a deployment in the servers- https://fixmultitenantissues.codeplex.com/

clip_image001

Let’s find a way out of this.

It’s possible to extend the tenant admin portal template to perform certain things such as adding a new link, removing a link etc.. But where are these links? If we have them, we can at least try to configure BCS and see if that functions well under partitioned mode, right?

Well, they are there!

You can find the SSS and BDC Application pages in the resource folders under the following path. These folders contain the pages used in these two applications. Finding these allows us to test the Business Data Connectivity Service functionality and embed the URLs to the tenant admin portals by extending the site template.

clip_image002

SSSvc folder contains the following items inside. Just copy the path and the page name at the end. The path would be “http://tenant.domain.net/admin/_layouts/15/sssvc/TA_ManageSSSvcApplication.aspx

clip_image003

Then BCS. Go to BDC folder and check if it has the following set of files. Path for that would be “http://tenant.domain.net/admin/_layouts/15/bdc/TA_ViewBDCApplication.aspx

Copy both these URLs to a notepad.

clip_image004

Now let’s add these links in to Tenant admin portal. For now we are adding these in to the left navigation so that if everything works well we can extend the template and add the links globally and permanently.

Open up the tenant admin portal and simply go to Site Settings –> Quick Launch, under the Look and feel section

clip_image005

Add new headings respectively

clip_image006

They should appear in the left panel right away.

clip_image007

Click on each, and you should be able to open up the applications now.

clip_image008

clip_image009

If everything goes well, you can go ahead and extend the layout templates. The following feature definition shows how to add a new group, several links, and remove the link to the Manage Site Collections page. Doing this allows us to globally enable the links across all tenant admin sites at once.

<Elements xmlns=”http://schemas.microsoft.com/sharepoint/”&gt;
<CustomActionGroup
Id=”TenantAdmin_HostingUserAccounts”
Location=”Microsoft.SharePoint.TenantAdministration”
Title=”User Accounts”
Sequence=”90″
ImageUrl=”_layouts/images/SiteSettings_UsersAndPermissions_48x48.png”>
<UrlAction
Url=”” />
</CustomActionGroup>
<CustomAction
Id=”TenantAdmin_HostingUserAccounts_AddUser”
GroupId=”TenantAdmin_HostingUserAccounts”
Location=”Microsoft.SharePoint.TenantAdministration”
Sequence=”10″
Title=”Create User”>
<UrlAction
Url=”_layouts/UserAccountsWebParts/UA_AddUsers.aspx” />
</CustomAction>
<CustomAction
Id=”TenantAdmin_HostingUserAccounts_ManageUsers”
GroupId=”TenantAdmin_HostingUserAccounts”
Location=”Microsoft.SharePoint.TenantAdministration”
Sequence=”30″
Title=”Manage Users”>
<UrlAction
Url=”_layouts/UserAccountsWebParts/UA_ManageUsers.aspx” />
</CustomAction>
<HideCustomAction
GroupId = “TenantAdmin_Sites”
HideActionId = “TenantAdmin_Sites_ManageSiteCollections”
Location=”Microsoft.SharePoint.TenantAdministration” />
</Elements>

Full details of extending the template is described in this TechNet article https://technet.microsoft.com/en-us/library/dn659286.aspx?f=255&MSPPError=-2147217396

InfoPath Error in SharePoint 2016: There has been an error while processing the form

Warning There has been an error while processing the form. click OK to resume filling out the form. You may want to check your form data for errors.

clip_image001[6]

Let me guess, you have gone through all possible verifications on data sources and form fields and everything pretty well developed and verified ? same goes for me. one of my colleague was developing a form and she came up with this error on SharePoint 2016 recently.

She was using GetUserProfileByName SOAP Web Service to fetch current user’s group in to a field, and that’s where this error prompts. that was verified by removing the particular connection and rules filling up data.

After verifying form fields, Data connections and other basics, I decided to inspect the infrastructure step by step. SharePoint logs and Event Log did not had any relevant entry. Finally in the lonely boat, I took following steps one after one to sail towards an island.

1. Enabled all InfoPath services from CA (General Application Settings) – Everything is already set

clip_image001[8]

clip_image002

clip_image003

2. Registered the HTMLCHKR – no luck

regsvr32 “C:\Program Files\Common Files\Microsoft Shared\OFFICE14\htmlchkr.dll”

  1. 3. Added the target site to InfoPath application’s trusted Locations – no luck
  2.  
  3. clip_image001[10]clip_image002[6]
  4. 4. Restarted and recycled Security Token Service Application/pool for all WFEs – no luck
  5. image
  6. 5. Restarted Servers – no luck

Two last steps were able to shed some lights !

6. Disabled loopback check

What is Loopback check?. If you have been prompted continuously for credentials in a SharePoint server when you try to access your site within that server, that’s obviously because of loopback.

Microsoft: Windows Server 2003 SP1 introduced a loopback security check. This feature is obviously also present in Windows Server 2008/12. The feature prevents access to a web application using a fully qualified domain name (FQDN) if an attempt to access it takes place from a machine that hosts that application. The end result is a 401.1 Access Denied from the web server and a logon failure in the event log.
Unfortunately 401.1 is not really helpful as this error code means there is a problem with the user credentials. Of course, the HTTP spec doesn’t know about security features in a vendor’s implementation so there can’t be a HTTP error code for such a feature. This can lead to much banging of the head on the desk. It’s one of numerous causes of the 401.1 which are nothing to do with invalid credentials (e.g. attempting to use Kernel Mode Authentication with domain account in IIS7).

Option1 : Logged in to target SharePoint Server/s and launch PowerShell as administrator, then ran – New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name “DisableLoopbackCheck” -value “1” -PropertyType dword)

You don’t need to add it if its exists (means loopback is already disabled)

clip_image001[4]

  1. Option 2: You can also Add this registry entry manually
  2. Click Start, click Run, type regedit, and then click OK
  3. In Registry Editor, locate the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
  4. Right-click Lsa, point to New, and then click DWORD Value. (In Win 2008, its DWORD 32bit)

Type DisableLoopbackCheck, and then press ENTER.

Right-click DisableLoopbackCheck, and then click Modify.

In the Value data box, type 1 and then click OK.

Quit Registry Editor.

  1. Then I ran SharePoint Product Configuration wizard on SharePoint Server just to give it a refreshment.

After restarting Servers, added the form connection and rules back and InfoPath form loaded perfectly normally !

SharePoint 2016 Product Configuration Wizard Error: Configuration Failed with Unauthorized Access Exception

If you are going to deploy SharePoint 2016, this is a common error that encountered.

clip_image001[4]

The error pretty much pointing to a Access permission which you might doubtlessly think its database permission but no it’s not !

clip_image002[4]

If you expand the event log, It will have 100, 104 errors logged due to this.

clip_image003[4]

Resolution is to permit setup account to access Tasks folder (C:\Windows\Task). This is a critical folder which needs to be able to access by the setup account during the Product Configuration.

To take the ownership of this folder, log in to relevant SharePoint server using a local admin account and right click on the Tasks folder.

clip_image004[4]

Under Security tab, go to Advance

clip_image005[4]

Change the Owner from SYSTEM to your Setup account (the account will be used to run Product Config Wizard)

clip_image006[4]

Once changed, the new owner can be seen as showed below.

Error-SPSetup

Repeat the same for all SharePoint Servers in your farm if you planned to have multiple. Now run the Product Configuration Wizard again and you will notice its smoothly passing to task 5. within few minutes, the Wizard will be successfully complete.

clip_image008[4]

And here comes the winning moment !

image

If you are still accounting with any additional errors in the Wizard, these points are some basic ones to verify.

Ensure:

  1. 1. Antivirus Disabled for all SharePoint and Database Servers (If any)
  2. 2. Firewall
  3. 3. Named Pipes in SQL Services enabled (Sometimes this isn’t enabled by default)

And then:

  1. 1. Disable UAC (Never Notify)
  2. 2. Restart Server
  3. 3. Run the Product Config Wizard again as Administrator

Enjoy the all new SharePoint !