Problems when trying to open a SharePoint Document Library in explorer view from Windows?

With errors like:

“Your client does not support opening this list with Windows Explorer.”

or in danish

”Klienten understøtter ikke åbning af denne liste med Windows Stifinder.”

Explorer view uses the WebDav protocol to connect to SharePoint from the client.

In Windows 7 or Windows Vista
Ensure the WebClient service is not disabled. The WebClient service is critical to the Open in Windows Explorer feature.

If already running and still not working try to restart the service.


In Windows Server 2008
The Windows Server is not designed to be a client and the WebDav client is not installed or enabled by default.
In order to enable the WebDav client on a server simply enable the Desktop Experience feature.

Tags: , | Categories: SharePoint Configuration | Tips and tricks

When trying to deploy a SharePoint solution in Visual Studio 2010 folowing errors can occur:

Error 1 Error occurred in deployment step 'Retract Solution': The local SharePoint server is not available. Check that the server is running and connected to the SharePoint farm.

Solution: make the account you are running Visual Studio a member of the db_owner role on the sharepoint_config and sharepoint_admin databases.

 

Error 1 Error occurred in deployment step 'Activate Features': Cannot start service SPUserCodeV4 on computer '...'.


Solution: go into Central Administration, select System Settings, select Manage services on server. Find the 'Microsoft SharePoint Foundation Sandbox Code Service' and click Start.

Tags: , | Categories: IDE | SharePoint Development | Tips and tricks
To create the asp.net membership database, please follow the steps below.
 
  1. Find the setup file aspnet_regsql.exe located at either of the following locations depending upon your OS:
    %windir%\Microsoft.NET\Framework\v2.0.5027
    %windir%\Microsoft.NET\Framework64\v2.0.5027
  2. When the ASP.NET SQL Server Setup Wizard appears, select “Configure SQL Server for application services”, then click Next
  3. Enter the SQL Server and Database name.
     
  4. Click Next and Finish

  To run the command line version of aspnet_regsql.exe, you need to open a command prompt and run this command, which will create the proper database tables for the membership database.
-- To use SQL Server credentials (a UserID and Password), use:

aspnet_regsql.exe -S <server> -U <login id> -P <password> -d <database> -A all
Tags: , , | Categories: Database | Tips and tricks | Web development

Ever run in to problems with SharePoint and to long url or problems with uploading documents deep down the file map path?

I have and I found some pretty stange limits.

The Office programs Excel and Word have different limitations when it comes to storing documents in SharePoint.
In a SharePoint document library with a long URL path there is a difference in the length of file names that can be saved.

  • Word can´t handle more than 262 characters in the URL. Incl. path and file name
  • Excel can´t handle more than 218 characters in the URL. Incl. path and file name
 
The reason that there even can exist as long paths to an Excel sheet is that the above limit only applies when you save the document from Excel / Word and not when you upload it with the send button or using the the Explorer view.
There is even an different transfer limit on the 2 ways to transfer documents, but thats another day.
 
General restrictions:
URL path for all files and folders to be less than 260 characters and must not exceed 128 characters in each file or folder name in the URL path.
But this is not when you save the document from Excel!
 
 
Tags: , , , , | Categories: SharePoint Configuration | SharePoint Development | Tips and tricks