Monday, March 12, 2012

Sandbox Solutions – SharePoint 2010

Microsoft introduced new concept called ‘Sandbox solution’ in SharePoint 2010 which will allow end user to deploy solution to their site collection (instead of deploying into farm), the user with proper privileges can deploy sandbox solutions.

Here are some links which talks about sandbox solutions in details:

ERROR: The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered

If we don’t have proper access into SQL Server database for opening Powershell window then we are getting above error, its new feature for SharePoint 2010 and SQL Server 2008.

We have to give DBO owner rights to SharePoint configuration database for ‘SharePoint_Shell_Access’ database role.

Reference Links:

ERROR: For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method

How to uninstall PowerPivot for SharePoint 2010

There are some post-uninstall verification steps we need to follow after uninstalling PowerPivot from the SharePoint 2010 environment and main uninstall take place from SQL Server side by removing PowerPivot features.

Reference links:

Export as data feed option is not coming in SharePoint list – PowerPivot Issues

After installing PowerPivot successfully, I was not able to see ‘Export as data feed’ option in list setting ribbon menu. Here is the link which will discuss about what are the possibilities for not having that option.