Add-PSSnapin Microsoft.SharePoint.PowerShell # Change here # App Pools $saAppPoolName = "SharePoint Web Services Default" # Change here # UPA specifics $upaInstanceName = "User Profile Service" $upsInstanceName = "User Profile Synchronization Service" $upaName = "User Profile Service Application" $databasePrefix = "PROD" $upaProfileDB = "Profile" $upaProfileDBName = $databasePrefix + "_" + $upaProfileDB $upaSocialDB = "Social" $upaSocialDBName = $databasePrefix + "_" + $upaSocialDB $upaSyncDB = "Sync" $upaSyncDBName = $databasePrefix + "_" + $upaSyncDB # Grab the Appplication Pool for Service Application Endpoint $saAppPool = Get-SPServiceApplicationPool $saAppPoolName <# Creates UPA Service Application & Proxy, and User Profile Service Instance If omitted, -ProfileSyncDBServer, -SocialDBServer & -ProfileDBServer are the SharePoint Default DB Server If omitted, -SyncInstanceMachine is the local machine #> Write-Host "Creating $upaName Application & Proxy..." $upa = New-SPProfileServiceApplication -PartitionMode -Name $upaName -ApplicationPool $saAppPoolName -ProfileDBName $upaProfileDBName -SocialDBName $upaSocialDBName -ProfileSyncDBName $upaSyncDBName New-SPProfileServiceApplicationProxy -PartitionMode -Name "$upaName Proxy" -ServiceApplication $upa -DefaultProxyGroup # Check it worked Get-SPServiceApplication | ? {$_.TypeName -eq "User Profile Service Application"}