Add a SharePoint 2010 RSS Viewer Web Part to a page and configure it to read from an external SSL (HTTPS:) feed. The following message will be displayed:

"The requested RSS could not be displayed. Please verify the settings and url for this feed. If this problem persists, please contact your administrator."

Checking the event logs of the web front ends will also show the following message:

"An operation failed because the following certificate has validation errors" ...

The problem is that SharePoint does not utilize the Windows certificate store, it maintains it's own. So, in order for the RSS Viewer to properly display the feed, the root Certificate Authority (CA) certificate must be added to SharePoint. To do this, perform the following steps:

Export Root Certificate

Create Central Administration Trust

The secure RSS feed should now display properly.

If you need to run T-SQL scripts/queries that utilize the xp_cmdshell stored procedure, SQL must be reconfigured to allow this:

Another thing to keep in mind is that the SQL Server service account must have permission to any files/folders that the stored procedure will create/modify/delete!

Copyright 2011 - 2021 The Lazy SharePoint Admin | All Rights Reserved
menu-circlecross-circle linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram