How to install SharePoint 2007 in workgroup environment

To install SharePoint 2007 in a workgroup farm environment, follow below steps:
 
  • Install SharePoint 2007 on web/app servers but dont run configuration wizard. At last step of installation on finish screen, uncheck "Run Configuration Wizard".
  • Now open command prompt and browse to folder "$\Program Files\Common Files\Microsoft Shared\web server extensions\12\bin"
  • Now type "PSConfig -cmd create -server <DBServerName> -database <SharePointConfig> -dbuser <SQLDBAdmin e.g. sa> -dbpassword <SQLUserPassword e.g. sa password> -user <FarmAdministrator> -password <FarmAdministratorPassword>"
  • Above command will create Config DB for you using SQL user rather than windows user as in workgroup environment, you cannot use windows user. Same command also configures Farm Administrator, but wait a second, we haven’t yet configured Central Administration.
  • To configure Central Administration site, type "PSConfig -cmd adminvs -provision -port <centraladministrationsiteport> -windowsauthprovider onlyusentlm".

Now you have configured your SharePoint Farm in a workgroup environment and have also setup your Central Administration Site without using configuration wizard.

Feature, Feature Stapler and Feature Staplee

Feature: New to the WSSv3 Platform is a concept called Features.  These enable you to package chunks of functionality and allow this functionality to be turned on or off in a WSSv3 based site
 
Feature Stapler: Feature Stapling allows you to “staple” a Feature to a site definition without modifying it in any way.  This means you can add your feature to all sites created using that site definition
 
Feature Staplee: To create a staple you actually create another Feature that does the staple and called Feature Staplee.
 

Scenario:  You want to run some custom code whenever a site is created. (a typical use of the ExecuteURL property in V2)

Solution:  Build a Feature that has an Event Receiver defined on it; & have it catch the Feature activation event.  Run your custom code in there.  Then, use a Feature Staple to staple your Feature to the site definition