Thursday, November 29, 2012

Error: SharePoint 2013: Central Administration - Service Unavailable: HTTP Error 503


Description


When attempting to open the SharePoint 2013 Central Administration Web site, the site does not come up, and there is an error:

"Service Unavailable.  HTTP Error 503. The Service is unavailable."


Cause


The SQL Server services are stopped because the domain Service Account used to run the SQL Server services is locked out.  This is visible from All Programs, Microsoft SQL Server 2012, Configuration Tools, SQL Server Configuration Manager.




Solution

In Active Directory Users and Computers, perform the following:
  • Unlock the Service Account
  • Ensure that the Service Account is not set to require user to change password at next login
  • Ensure that the password never expires
  • Verify Group Policies on the Organizational Unit to ensure that the account password is not being expired as a result of an effective policy.  If so, change the policy inheritance on the OU.
  • If possible, reboot the SQL Server or manually start all of the services that were affected by the account lockout.

Tuesday, November 27, 2012

SharePoint 2013: How to Configure Subscription Settings Service Application using PowerShell

Last Updated March 28, 2014



Description

This post describes how to configure the SharePoint Server 2013 Subscription Settings Service Application using PowerShell.

Solution

1)  Document the Naming Convention






Document a naming convention for each of the Subscription Settings Service Application components.

Example:
Application Pool Service Account:  Domain\SvcAccount (this should already be created)
Application Pool: SvcApp_SPServiceApplicationPool_03 (this should already be created)
Service Application: SvcApp_SPSubscriptionSettingsServiceApplication_01
Service Application Database: SvcApp_SPSubscriptionSettingsServiceApplication_01_DB_01 

Service Application Proxy:  The Proxy is named automatically by SharePoint 

2)  Open the SharePoint 2013 Management Shell as Administrator.

3)  Verify the Name of the Application Pool.
PS C:\ Get-SPServiceApplicationPool | Select Name

4)  Set the Service Application Pool in a variable.
$SvcAppPool03 = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_03"

5)  Create the Service Application and assign it to the Application Pool.
$SvcApp = New-SPSubscriptionSettingsServiceApplication -ApplicationPool $SvcAppPool03 -Name "SvcApp_SPSubscriptionSettingsServiceApplication_01" -DatabaseName "SvcApp_SPSubscriptionSettingsServiceApplication_01_DB_01" -DatabaseServer "MSSQL Client Alias"
 
6)  Verify the Service Application.
PS C:\ Get-SPServiceApplication | Select Name

5)  Create the Service Application Proxy and assign it to the Service Application.
$SvcAppProxy = New-SPSubscriptionSettingsServiceApplicationProxy -ServiceApplication $SvcApp

It does not appear that the name of the Proxy can be set using the cmdlet.  SharePoint will name the Proxy automatically.

7)  Verify Service Application Proxy.
PS C:\ Get-SPServiceApplicationProxy | Select Name

8)  Start the Service Instance.
Get-SPServiceInstance | where{$_.TypeName -eq "Microsoft SharePoint Foundation Subscription Settings Service"} | Start-SPServiceInstance


References

Microsoft TechNet (2012).  New-SPSubscriptionSettingsServiceApplication.  Retrieved November 27, 2012 from http://technet.microsoft.com/en-us/library/ff607823.aspx.

Microsoft TechNet (2012).  Service application cmdlets in SharePoint 2013.  Retrieved November 27, 2012 from http://technet.microsoft.com/en-us/library/ee906561.aspx.

Microsoft TechNet (2012).  SharePoint 2013 - Service Applications.  Retrieved November 27, 2012 from http://social.technet.microsoft.com/wiki/contents/articles/12512.sharepoint-2013-service-applications.aspx.

SharePoint 2013: How to Configure State Service Application using PowerShell

Last Updated March 28, 2014 

Description

This post describes how to configure the SharePoint Server 2013 State Service Application using PowerShell.

Solution


1)  Document the Naming Convention
.
Document a naming convention for each of the State Service Application components.
Example:
Application Pool Service Account:  Domain\SvcAccount (this should already be created)
Application Pool: SvcApp_SPServiceApplicationPool_02 (this should already be created)
Service Application:  SvcApp_SPStateServiceApplication_01
Service Application Database:  SvcApp_SPStateServiceApplication_01_DB_01
Service Application Proxy:  SvcApp_SPStateServiceApplication_01_Proxy_01
2)  Open the SharePoint 2013 Management Shell as Administrator.

3)  Verify the Name of the Application Pool.
Get-SPServiceApplicationPool | Select Name

4)  Set the Service Application Pool in a variable.

$SvcAppPool02 = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_02"

5)  Create the Service Application and assign it to the Application Pool.
 
New-SPStateServiceDatabase -Name SvcApp_SPStateServiceApplication_01_DB_01 | New-SPStateServiceApplication -Name SvcApp_SPStateServiceApplication_01 | New-SPStateServiceApplicationProxy -Name SvcApp_SPStateServiceApplication_01_Proxy_01 | -DefaultProxyGroup
6) Verify State Service Application.
Get-SPStateServiceApplication | Select Name

7)  Verify State Service Database.
Get-SPStateServiceDatabase | Select Name

9) Verify State Service Application Proxy.
Get-SPStateServiceApplicationProxy | Select Name


References

Microsoft TechNet (2012).  New-SPStateServiceApplication.  Retrieved November 27, 2012 from http://technet.microsoft.com/en-us/library/ff608084.aspx.

Microsoft TechNet (2012).  Service application cmdlets in SharePoint 2013.  Retrieved November 27, 2012 from http://technet.microsoft.com/en-us/library/ee906561.aspx.

Microsoft TechNet (2012).  SharePoint 2013 - Service Applications.  Retrieved November 27, 2012 from http://social.technet.microsoft.com/wiki/contents/articles/12512.sharepoint-2013-service-applications.aspx.

Microsoft TechNet (2012).  State service and session state cmdlets in SharePoint 2013.  Retrieved November 27, 2012 from http://technet.microsoft.com/en-us/library/ee890113.aspx.