<#====================================================================
Copyright © 2015, September. Michael Pomfret
Creates the State Service Application
Provides temporary storage of user session data for SharePoint Server components.
Read more: http://technet.microsoft.com/en-us/library/ee704548.aspx
====================================================================#>
#Allows to use SharePoint cmdlets from inside the Windows PowerShell command window
If ((Get-PsSnapin |?{$_.Name -eq “Microsoft.SharePoint.PowerShell”})-eq $null)
{
Add-PsSnapin Microsoft.SharePoint.PowerShell | Out-Null
}
<#====================================================================
Get SharePoint variables
====================================================================#>
Add-Module(“C:\Temp\SharePoint2013\GetVariables.ps1”)
function Add-Module($strFileName){
Write-Host “Attempting to run ” $strFileName
If (Test-Path $strFileName){
&($strFileName)
}Else{
Write-Host “Cannot locate” $strFileName
}
}
#Get default SQL server
$DefaultDatabaseServer = (Get-SPDatabase | ? { $_.Type -eq “Configuration Database” }).NormalizedDataSource
#Get SQL server instance for the User Profile Application, Social,
$DatabaseServer = $StateServerInstance
$ServiceApplicationName = “State Service Application”
$DatabaseName = ‘State Service Application’
$MachinesToActivate = $StateMachinesToActivate.Split(“,”).trim()
Write-Host “”
Write-Host “========================================================”
Write-Host “SharePoint 2013 – Module ‘$ServiceApplicationName’…”
Write-Host “To SharePoint Servers” $MachinesToActivate
Write-Host “Application Pool Name -” $spAppPoolName
Write-Host “Application Pool Account – -” $spAppPoolAcc
Write-Host “Database Server Instance -” $DatabaseServer
Write-Host “Configuration DB -” $ConfigDB
Write-Host “========================================================”
Write-Host “”
Start-SPAssignment -Global | Out-Null
try
{
#Check for existing service application and proxy
$ExistingServiceApp = Get-SPServiceApplication | where-object {$_.Name -eq $ServiceApplicationName}
if ($ExistingServiceApp -eq $null)
{
Write-Host ” – Creating ‘$ServiceApplicationName'”
New-SPStateServiceDatabase -Name $DatabaseName | Out-Null
New-SPStateServiceApplication -Name “State Service Application” -Database $DatabaseName | Out-Null
Get-SPStateServiceDatabase | Initialize-SPStateServiceDatabase | Out-Null
#Create proxy
write-host ” – Creating ‘$ServiceApplicationName proxy'”
Get-SPStateServiceApplication | New-SPStateServiceApplicationProxy -Name “$ServiceApplicationName Proxy” | Out-Null
Write-Host ” – Done creating ‘$ServiceApplicationName’.`n”
}else{
Write-Host -f Red $strTest” – ServiceApplication ‘$ServiceApplicationName’ already exists.”
#Remove Application?
$RemoveApplication=read-host ‘Do you wish to remove Application? (Y/N)’
if ($RemoveApplication-eq”Y”)
{
write-host ” – Removing ‘$ServiceApplicationName’…”
Remove-SPServiceApplication $ExistingServiceApp -removedata -Confirm:$false
#Proxy is NOT automatically deleted
$ExistingServiceAppProxy = Get-SPServiceApplicationProxy | where-object {$_.Name -eq “$ServiceApplicationName Proxy”}
if ($ExistingServiceAppProxy -ne $null)
{
write-host ” – Removing ‘$ServiceApplicationName proxy’…”
Remove-SPServiceApplicationProxy $ExistingServiceAppProxy -Confirm:$false
}
write-host ” – Stopping service instance…”
Get-SPServiceInstance | where-object {$_.TypeName -eq $ServiceName} | Stop-SPServiceInstance -Confirm:$false | Out-Null
}
}
}
catch { write-Output $_ }
Stop-SPAssignment -Global | Out-Null