Share via

Configure a SharePoint server in non domain(Workgroup) environment

  • Article

Hi All,

Lets try to configure a SharePoint farm in a workgroup environment. Normally if we have to configure a SharePoint on a Workgroup environment the only option available to us is Standalone environment. Let's try to understand how we can configure a SharePoint farm environment in a Workgroup environment. We need to run below PowerShell commands.

If you use this approach, you must update passphrase and SQL server name in the below PowerShell script. We have SharePoint and SQL installed on the same machine. Make sure account used during FarmAccount has access/authority to SQL server.

1.$FarmAccount = Get-Credential
2.$PassPhrase = "FarmPassphrase"
3.$FarmPassphrase = (ConvertTo-SecureString $PassPhrase -AsPlainText -force)
4.$FarmConfigDatabase = "Wss_config_2"
5.$AdminContentDatabase = "SPFarm_Admin_ContentDB_2"
6.$CentralAdminPort = 8080
7.New-SPConfigurationDatabase -DatabaseServer (SQLservername) -DatabaseName $FarmConfigDatabase -AdministrationContentDatabaseName $AdminContentDatabase -Passphrase $FarmPassphrase -FarmCredentials $FarmAccount

Now let’s move a steps ahead and try to use different server for SharePoint and SQL server. Here we created a SQL user account and updated credentials in dbcredential.

1.$dbcredential = New-Object –typename System.Management.Automation.PSCredential –argumentlist  "SQLuser", (ConvertTo-secureString "SQLpassword"  –AsPlainText –Force)
2.$PassPhrase = "FarmPassphrase"
3.$FarmPassphrase = (ConvertTo-SecureString $PassPhrase -AsPlainText -force)
4.$FarmConfigDatabase = "Wss_config"
5.$AdminContentDatabase = "SPFarm_Admin_ContentDB"
6.$CentralAdminPort = 8080
7.$FarmAccount = Get-Credential
8.New-SPConfigurationDatabase -DatabaseServer "SQLservername"  -DatabaseName $FarmConfigDatabase -AdministrationContentDatabaseName $AdminContentDatabase -Passphrase $FarmPassphrase -FarmCredentials $FarmAccount -DatabaseCredentials $dbcredential

http://itfreesupport.com/wp-content/uploads/2015/03/0227-300x128.png

http://itfreesupport.com/wp-content/uploads/2015/03/0228.png

Note: We still cannot create a Multiple SharePoint server farm in Workgroup environment. Using the above script you can connect only 1 SharePoint server with a SQL server instance.

Reference : http://itfreesupport.com/2015/03/configure-a-sharepoint-server-in-non-domainworkgroup-environment/