SharePoint 2013 – The root of the certificate chain is not a trusted root authority

This is quick one. A ticket was generated from a client to fix the error on their existing SharePoint 2013 UAT environment. The error read something similar to this. The key error was “The root of the certificate chain is not a trusted root authority”,

Critical   An operation failed because the following certificate has validation errors:\n\nSubject Name: CN=*********.********.com, OU=*****, O=********, L=*****, S=*****, …………… The root of the certificate chain is not a trusted root authority..        

There is already a KB article for this.

As mentioned in the resolution section:

In order to resolve this problem, the local trust relationship has to be created. This can be done by running the following PowerShell commands

$rootCert = (Get-SPCertificateAuthority).RootCertificate
New-SPTrustedRootAuthority -Name “localNew” -Certificate $rootCert

After running the above commands, perform an IISReset on all servers in the farm.

PowerPivot Management Dashboard – Error

Recently I encountered an error with PowerPivot Management dashboard at a client site. The error read:

We do not know what happened, but something went wrong.

Could you please try that again?




It was a quick fix as they were missing required permission on SharePoint Admin content database.

You will need Excel Services App Pool account to have SPDataAccess permission on Admin content database.



Avoiding accidentally sending email to user when assigning permission in SharePoint 2013

In SharePoint 2013 when you assign permission to a user you do not want to notify them using SharePoint email notification. This could be for various reason. I am not going to discuss why given that’s not the point.

Now on assign user permission dialog “Send an Email Invitation” checkbox is partially hidden. The reason I say it’s partially hidden is because you do not see the checkbox until you click Show Options link at the bottom of the dialog.

Note:  You will not see the checkbox if you have not configured outgoing email in your farm.

Continue reading