Skip to main content

Thinking out aloud - Dave Hunter's SharePoint Blog

Go Search
Home
Blog
  

Home > Thinking out aloud - Dave Hunter's SharePoint Blog > Categories
SharePoint UK User Group - Thursday 27th August London Meeting

I was planning to attend the SharePoint UK User Group on Thursday for the Best Practices in Gathering Requirements for SharePoint Projects.  The event had Dux speaking at the event.

Important news, Dux can't make the event so its now going to be a virtual event instead of being held at Microsoft's offices in Victoria London.  Please see an update here http://suguk.org/forums/thread/20502.aspx.

SharePoint 2007 Post SP1 Issues - Event ID 5214

I've been recently building some SharePoint Virtual Machines, looking at the media I had available which was SharePoint 2007 RTM, I decided it was best to get a fresh copy of SharePoint 2007 with SP1.  I planned to install the Infrastructure Update and instead of installing RTM, applying WSS SP1 and MOSS SP1 and Infrastructure for WSS and MOSS - 4 updates in total sounded daunting.

After installing MOSS SP1 I started to configure the services, during this I got the usual and scary "Cannot complete this action" error, especially as I've used MOSS SP1 before without any errors.

The errors in the event log are:

-----------------------------------------------------------------------------------------------------------------------------

Event Type: Error

Event Source: Windows SharePoint Services 3

Event Category: Database

Event ID: 5214

Date: 04/12/2008

Time: 14:37:38

User: N/A

Computer: COMPUTER_NAME

Description:

Insufficient SQL database permissions for user 'MOSS DATABASE ACCESS ACCOUNT' in database 'SharePoint_AdminContent_c4cfffb3-2065-49e4-b705-33b11b07fcf9' on SQL Server instance 'COMPUTER_NAME'. Additional error information from SQL Server is included below.

EXECUTE permission denied on object 'proc_GetWebNavStruct', database 'SharePoint_AdminContent_c4cfffb3-2065-49e4-b705-33b11b07fcf9', schema 'dbo'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

-----------------------------------------------------------------------------------------------------------------------------

Event Type: Error

Event Source: Windows SharePoint Services 3

Event Category: Database

Event ID: 5214

Date: 04/12/2008

Time: 14:37:38

User: N/A

Computer: COMPUTER_NAME

Description:

Insufficient SQL database permissions for user 'MOSS DATABASE ACCESS ACCOUNT' in database 'SharePoint_AdminContent_c4cfffb3-2065-49e4-b705-33b11b07fcf9' on SQL Server instance 'COMPUTER_NAME'. Additional error information from SQL Server is included below.

EXECUTE permission denied on object 'proc_GetWebNavAcls', database 'SharePoint_AdminContent_c4cfffb3-2065-49e4-b705-33b11b07fcf9', schema 'dbo'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

-----------------------------------------------------------------------------------------------------------------------------

I haven't installed SharePoint for a while so questioned whether the permissions were correct.  I have four accounts:

Account Purpose Privileges
Set up user Person who installs and configures SharePoint Member of the administrators group for each WFE
Database Access Account Used as the main service account for MOSS and the Application pool user for CA.

Service account with SQL Roles (DB Creator and Security Admin) privileges and a member of local Administrators group

Server Farm Account Used to run services and identity of application pools Member of the administrators group
Default Content Access Account Used to index content None

 

The account the error message complains about is the database access account, but this has DB Creator and Security Administration.  I reviewed the following information here "Event ID 5214 (Windows SharePoint Services health model)" - http://technet.microsoft.com/en-us/library/cc561019.aspx with no success.

After looking further I found this http://www.eggheadcafe.com/software/aspnet/33333060/execute-permission-was-de.aspx where it was confirmed as a known issue and that the August 2008 update resolves this.  For more information please see http://support.microsoft.com/default.aspx/kb/956056/

I choose to install the Infrastructure Update which rolls up these updates.  For more information please see:

Please read the notes carefully, with any update you cannot un-install and with MOSS you need to install the WSS update first and then apply the MOSS version of the update.

History of SharePoint

Joining Dots have a great article about the history of SharePoint.  You can read the article here.  They also have a diagram explaining where SharePoint 2007 has come from and its features.

Joining Dots

 

I've worked with Microsoft CMS just after Microsoft acquired nCompass, then onto MCMS 2002, SharePoint v2 technologies and through to MOSS.  These products have changed over the years, technology and focus.  You programmed against MCMS 2001 using ASP 3 / VBScript and Microsoft CMS 2002 in .NET.

SharePoint 2001 was more focused on Document Management.  The markets changed and collaboration was the main focus.  With MOSS it can feasibly target all markets (Document Management, Content Management, Collaboration, Records Management, Business Intelligence, Business Process and Enterprise Search).  Get yourself a piece of the MOSS pie :)

SharePoint Designer - stop that lag when loading

SharePoint Designer (SPD) by default loads the last site you were using when it opens.  I know this is a "feature" and has it benefits when you are working on one site, but I find myself realising that its opening the last site and frantically clicking the stop button in hoping that it will stop loading swiftly.

stop

You can turn this feature off, select Tools > Application Options

You will be presented with the following

spd_options

De-select the first option and click OK.

SharePoint vNext – Rumours, Speculation and Confirmed Features

The table below lists the known facts about what we can expect in SharePoint vNext and their probability of happening or making the version.

Feature

Summary

Probability

Source(s)

64 bit only

SharePoint vNext will be a 64 bit version only.

CONFIRMED

TechNet

Silverlight

Silverlight 2.0 webparts or UI will be present.

MOST PROBABLY

Speculation

Super-Lists

SQL tables-like behaviour for SharePoint lists

PROBABLY

Bill Gates

Groove Integration

If the user has Groove client installed, more options will be displayed for data synchronization, in more seamless way.

PROBABLY

Ray Ozzie

Master Data Management

Master data source for keeping only one version of the truth. This data can be surfaced as SQL Server views or SharePoint data. In essence, a rebranded and somewhat expanded version of Stratature product +EDM, now known as Codename "Bulldog".

MOST PROBABLY

Wikipedia
Microsoft MDM

XHTML-compliant output

SharePoint UI will produce clean XHTML-compliant output.

PROBABLY

Speculation

FAST search integration

FAST-based enterprise search as a Search replacement. Webparts that show FAST search results.

MAYBE

CMS Watch

ODF and PDF support

Custom filters won't be necessary to index and extract metadata from ODF and PDF files.

PROBABLY

Microsoft

CMIS support

Content Management Interoperability Services will allow SharePoint to communicate with other ECMs via web services.

MOST PROBABLY

Microsoft

Claims-based Authentication mechanism

Decouples the authentication mechanism from its implementation. It will enable SharePoint to use any interoperable authentication mechanism to authenticate the users.

MAYBE

Network World

 

Thanks to Edin for compiling this list http://edinkapic.blogspot.com/2008/10/sharepoint-v14-2009-feature-list.html.

We've known about the 64 bit feature for some time now and have been recommending 64 bit server deployments ever since (for both performance reasons and future proofing customers environments). Microsoft have released some more information about CMIS here http://blogs.msdn.com/ecm/archive/2008/09/09/announcing-the-content-management-interoperability-services-cmis-specification.aspx.

 

SharePoint 2007 Delving into Articles
You may have read some of my articles in the series of "Delving into".  These articles provide an indepth view on an area in SharePoint 2007.
 
Articles already in this series:

Articles Coming Soon

  • Delving into SharePoint 2007 Features
  • Delving into SharePoint 2007 Site Columns
  • Delving into SharePoint 2007 Content Types
Delving into SharePoint 2007 Personalisation

In SharePoint there are two types of modifications to sites; customisation and personalisation.  Customisation relates to changes for all users, this view of SharePoint is the "shared view".  The Shared View is a standard view of the page available to everyone.  Personalisation relates to a change made by an individual user on a per user basis, this view is the "personal view".

Enabling Personalised Views

Before you can start personalising pages you will need to enabling personalisation for users.  Personalisation features are enabled by granting rights for users in the Shared Services Provider.

  1. Navigate to the Shared Service Provider Administration website.
  2. Click on "Personalization services permissions".
  3. Add an individual user or group and grant rights for "Personal Features".

Personal Features allows users to personalise pages.  Personal Site allows users to have a MySite.

Please note: If you have NT Authority\Authenticated Users group listed with Personal Features you are allowing all domain users to personalise pages.

Now we have granted users the correct rights for personalisation, lets move onto personalising pages.

Personalising the page (personal views)

  1. Navigate to the desired page that you wish to personalise.
  2. Click on the "Welcome User Name" down arrow and select "Personalize this page". 
  3. The page can now be customised to your needs.
  4. After you have finished making changes, click on "exit personal view".

The screenshot below shows a personalised team site homepage with a new webpart for user's tasks.

When you personalise a page it will show up as the default view.  To show the "Shared View" again, click the "Show Shared View".

Resetting page content

  1. Navigate to the page that you wish to reset back to the "Shared View".
  2. Click on the "Welcome User Name" down arrow and select "Reset Page Content". 
  3. Click OK on the dialog.

When navigating back to this page the "Shared View" will be shown as the default (the "Personal View" no longer exists).

The screenshot below shows the shared view of the team site homepage.

Personalisation with WebParts

WebParts have configuration properties, typically these are set by the site collection owner or a user with the correct rights. These settings are applied to the "Shared View". When you create properties for webparts you can set the scope whether they are "Shared" or "User" personalisable properties. For example:

A Shared Property

[Personalizable(PersonalizationScope.Shared),
WebBrowsable(true),
WebDisplayName("RSS Feed Url"),
WebDescription("Location of RSS feed for control to display")]
public string RssFeedUrl
{
  get { return rssFeedUrl; }
  set { rssFeedUrl = value; }
}

A User Personalisable Property

[Personalizable(PersonalizationScope.User),
WebBrowsable(true),
WebDisplayName("Post Content"),
WebDescription("Show Titles or Full body of the post")]
public DisplayMode PostContent
{
  get { return postContent; }
  set { postContent = value; }
}

The enumeration PersonalizationScope controls whether the property is a shared customisation or a user customisation.

Considerations regarding enabling personalisation

Personalisation has a higher cost on performance than customisation.  For each user request SharePoint needs to decide which view to display to the user (whether the user has customised the page and needs to see the "personal view" or "shared view").  Because of this personalisation should be planned for and implemented with a good level of control / caution.

The content database stores shared and personalised versions of pages.  When a page is personalised the user personalised version is stored seperately in the content database to the shared version.  If 10 users personalise the homepage of a team site, the content database will hold 11 versions of the team site homepage (10 user personalised versions and 1 shared version).

MySites are a personalisable area for users.  They are designed for uses to modify and customise to help them carry out their daily jobs.  They have their personal view and shared view.  You should look into utilising MySites instead of enabling personal views, both have pros and cons.

Troubleshooting

  • The "Personalize this page" link may not appear if the page is checked out.
  • Whilst personalising the page if users can't move webparts between zones you may need to perform the following:
    • Verify the webparts have "Allow Close" and "Allow Hide".
    • Make sure the webpart zones allow personalization.  This is set using SharePoint Designer.
  • If user personalisation breaks the user's view and you can no longer see the page in order to reset the page content, pasting in the following command into the address bar of the web browser will call the same command.

javascript:MSOWebPartPage_RestorePageDefault();

Hope this helps

Passed 070-541 and 070-630 exams
I was busy taking exams yesterday.  I sat the 070-541 WSS Application Development and the 070-630 MOSS Configuration.  I passed them both with high scores!
 
I revised for both exams using Microsoft e-learning collection courses http://www.microsoft.com/learning/elearning.mspx and MPress books
 
 
 
The WSS book by Ted Pattison is written very well and is the best SharePoint developers book I have read.
 
Updated:
 
Micorosft Prep Guides

Prometric test site (book exams etc) http://www.prometric.com/.

Robots.txt and MOSS
You learn something new every day.  I knew that a robots.txt file lived in the root of a web site and provided the crawler or bot with instructions to index or exclude certain files or paths.  I didn't know that SPS 2003 and MOSS supports and fully respects the instructions in the robots.txt.
 
 
A point to note is that the robots.txt is cached for 24 hours.  If you have modified this file the instructions will not be processed until the next day or if you restart the Office SharePoint Server Search Service.
Preview into WSS 3.0 SP1 and SharePoint Server 2007 SP1
The Microsoft SharePoint team have released some details about the much awaited release of Service Pack 1 for MOSS and WSS V3.  For more information please see: http://blogs.msdn.com/sharepoint/archive/2007/11/29/preview-into-wss-3-0-sp1-and-sharepoint-server-2007-sp1.aspx.
 
Quick summary:
  • Windows 2008 Support and Compatibility.
  • Support and Compatibility for ASP.NET for AJAX (including AJAX Control Toolkit for ASP.NET and AJAX 1.0 Extenstions).
  • New STSADM commands
    • Merge content
    • Renamesite
    • Peoplepicker
  • Rollup of 60+ hotfixes!

As for availability, Arpan Shah hinted it should be released to the public between now and end of Q1 2008.

1 - 10 Next

 Latest Posts

I’m attending the first ever SharePoint Saturday in the UK31/08/2010 19:43
I’ve re-joined CIBER UK31/08/2010 19:26
I’ve been Awarded a MVP for SharePoint01/04/2010 19:49
SharePoint 2010 Training on Microsoft E-Learning15/03/2010 17:56
SharePoint UK User Group - Thursday 27th August London Meeting25/08/2009 17:56
CAML Query that filters on the current user23/07/2009 17:50
Microsoft Ramp Up Free SharePoint Developer Training22/07/2009 20:59
How To: Change a SharePoint Application Pool Programmatically07/07/2009 18:08
SharePoint Forums Topping 100 Answers06/07/2009 12:29
Find out the SharePoint Internal Name for a Column or Site Column28/05/2009 09:56
1 - 10 Next