SharePoint Designer 2010: Business data connectivity metadata store is unavailable

If you see Business data connectivity metadata store is unavailable error in SP Designer 2010 then try to run the below powershell command. It got resolved the problem for me.

$bcsServiceApp = Get-SPServiceApplication | where {$_ -match "Business Data Connectivity Service"}
$bcsServiceApp.RevertToSelfAllowed = $true;
$bcsServiceApp.Update();

Command to activate site collection publishing feature

stsadm -o activatefeature -name publishingsite -url http://sitecollection -force

Finding the Id (Guid) for a SharePoint List

There are times when you need to find the Id (a Guid) of a list – for example, when setting the Task list to be used with SharePoint Designer Workflows (see my blog post here). Here’s a simple way of doing this:

Navigate to the SharePoint list using the browser.
Select the Settings + List Settings menu command.
Copy the Url from the browser address bar into Notepad. It will look something like:
http://moss2007/ProjectX/_layouts/listedit.aspx?List=%7B26534EF9%2DAB3A%2D46E0%2DAE56%2DEFF168BE562F%7D

Delete everying before and including “List=”.
Change “%7B” to “{”
Change all “%2D” to “-“
Chnage “%7D” to “}”
You are now left with the Id:

{26534EF9-AB3A-46E0-AE56-EFF168BE562F}

How To Change The maximum file size Upload in SharePoint 2010

This morning I tried to upload a large file to our SharePoint 2010 and then realised that the default 50mb file size limit was still set so while I was changing the settings to allow larger files I thought I would do a quick post on how/where the setting is and what to change.

First of all login to Central Admin and navigate to
Central Administration -> Application Management -> Manage Web Applications
Once there highlight the web application that you want to change and then click on general settings

Once in general settings scroll to the bottom of the list and you will see the maximum upload size the default setting is 50mb and change maximum size of 100mb or more.

Business Connectivity Services security operations (SharePoint Foundation 2010)

Below technet article explains more about the Security settings for BCS

http://technet.microsoft.com/en-us/library/ff973113.aspx#store

BCS Authentication issues Login failed for user NT Authority\ANONYMOUS LOGON or access denied by Business Data Connectivity

http://niranjanrao.wordpress.com/2012/01/12/bcs-authentication-issues-login-failed-for-user-nt-authorityanonymous-logon-or-access-denied-by-bcs/

Poweshell Script to enable Revert To Self on Server

$bdc = Get-SPServiceApplication | where {$_ -match “Business Data Connectivity Service”};
$bdc.RevertToSelfAllowed = $true;
$bdc.Update();

SharePoint V3: Error: Failed to activate feature 'PublishingPrerequisites'

Description:

Receiving error when attempting to activate the Office SharePoint Server Publishing Infrastructure, site collection feature:

Error: Failed to activate feature 'PublishingPrerequisites'


Solution:

- Run IISReset on the front end web servers
Start > Run > CMD > iisreset /noforce

- Activate the feature
Site Actions > Site Settings > Site Collection Features > Office SharePoint Server Publishing Infrastructure > Activate

SharePoint 2010 Enable Visual Upgrade on Sites with PowerShell

To enable the look and feel choice back to enabled on every site within a site collection, use the script below. Replace SiteCollection with the actual URL for your site collection.

$SiteCollection=Get-SPsite http://SiteCollection
foreach($SPWeb in $SiteCollection.AllWebs){$SPWeb.UIversionConfigurationEnabled=$true;$SPWeb.update();}

To enable the look and feel choice back to enabled on a single site use the following command. Replace Site with the actual URL for your site/web.

$Site=Get-SPWeb http://Site
$Site.UIversionConfigurationEnabled=$true;$Site.update();

Next tip I will show you how you can go back and forth between look and feel versions even on a brand new 2010 site. So if you just love the WSS 3.0 site look you can get that too right in SharePoint 2010.