Tag Archives: SharePoint 2010

Cannot use Open with Explorer in a SharePoint library – solved.


Cannot use Open with Explorer in a SharePoint library – solved. (“Your client does not support opening this list with Windows Explorer”)

The problem.

When browsing in a SharePoint document library, there is an option on the ribbon bar to Open with Explorer.  This is very exciting because you could copy and paste multiple files into SharePoint or move them from one folder to another.  When clicking on this button you get “Your client does not support opening this list with Windows Explorer”.

The solution.

The solution is to add a registry entry.  The root problem is that in this situation, your credentials are not passed when the target URL has a dot in the address.  The following procedure, from this Microsoft article describes how to fix things:

  1. Click Start, type regedit in the Start Search box, and then press ENTER.
  2. Locate and then click the following registry subkey:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters
  3. On the Edit menu, point to New, and then click Multi-String Value.
  4. Type AuthForwardServerList, and then press ENTER.
  5. On the Edit menu, click Modify.
  6. In the Value data box, type the URL of the server that hosts the Web share, and then click OK.
    Note   You can also type a list of URLs in the Value data box. For more information, see the “Sample URL list” section in this article.
  7. Exit Registry Editor.
Advertisement

The correct order to set up a single server PowerPivot installation.


The order in which you install SQL Server 2008 R2, SharePoint 2010, and PowerPivot for SharePoint on a single server currently matters.  There is a glitch that occurs when you install some components of SQL Server 2008 R2 prior to installing PowerPivot.

This is the order that works for me:

  1. Provision a new Windows 2008 SP2 server.
  2. Add IIS role.
  3. Make it a domain controller with dcpromo.
  4. Install SharePoint 2010 prerequisites.
  5. Install SharePoint 2010, do not check configure at the end.
  6. Install PowerPivot instance (choose new server) from SQL Server 2008 R2 installation.

Now you may install any other instances of SQL Server 2008 R2.

 Here is a link that helped me identify the problem:

http://powerpivotgeek.com/2010/06/14/installation-failure-could-not-load-file-or-assembly-microsoft-analysisservices-sharepoint-integration-dll/