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.