SharePoint 2013 How to Work with Logs when Troubleshooting Errors

Description

The post describes how to use Diagnostic Logging to help troubleshoot issues with SharePoint 2013.


Solution


1) Get the Path of the Trace Log

a) Open a remote desktop session to a server that has SharePoint installed (e.g. Web Front End server).

b)  Start, Programs, SharePoint, right-click SharePoint Central Administration, and click Run as Administrator.  If prompted for a confirmation about running SharePoint Configuration Wizard, click Yes.  This will launch SharePoint Central Administration in Internet Explorer.

c)  From Central Administration, navigate to Monitoring, Reporting, and Configure Diagnostic Logging.  The Path is located in the Trace Log section of the page.  Open this path in Windows Explorer.

2) Increase the diagnostic logging level

From the Configure Diagnostic Logging page (Central Administration, navigate to Monitoring, Reporting, and Configure Diagnostic Logging), check the box for All Categories and then set the logging level for "Least critical event to report to the trace log" to Verbose.  Then click OK.

Note:  It is better to choose only the categories that are applicable to the problem you are troubleshooting.



3) End the current log file and generate a new log file

a)  Start, Programs, SharePoint, right-click SharePoint Management Shell, and click Run as Administrator.

b)  Type New-SPLogFile and press Enter.  This ends the current log file and starts a new log file.





c)  Open the Trace Log Path in Windows Explorer to confirm that a new log file has been created.

4) Recreate the Problem

Perform the steps required to recreate the problem that you were originally troubleshooting.

5) End the current log file and generate a new log file

In the SharePoint Management Shell, type New-SPLogFile and press Enter.  Using Windows Explorer you can confirm that you now have a log file for a short period of time when you captured the error.

6) Reset the diagnostic logging level

From the Configure Diagnostic Logging page (Central Administration, navigate to Monitoring, Reporting, and Configure Diagnostic Logging), check the box for All Categories and then set the logging level for "Least critical event to report to the trace log" to Reset to default.  Then click OK.

7) Review the log file

Open the log file and search for keywords related the problem.  For example, search for "error" or "warning".



Key Words
Diagnostic Logging, Trace Log, SharePoint Troubleshooting


References

Microsoft TechNet (May, 2010).  Diagnostic logging is set to verbose (SharePoint Foundation 2010).  Retrieved January 18, 2016 from https://technet.microsoft.com/en-us/library/ff717836(v=office.14).aspx.

SharePoint 2013: How to Configure Visio Graphics Service Application using PowerShell

Last Updated March 28, 2014



Description

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

Solution

1)  Document the Naming Convention

Determine a naming convention for each of the Visio Graphics Service Application components.  Document the naming convention.

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_SPVisioServiceApplication_01 
Service Application Proxy:  SvcApp_SPVisioServiceApplication_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.
$SvcApp = New-SPVisioServiceApplication -ApplicationPool $SvcAppPool02 -Name "SvcApp_SPVisioServiceApplication_01"
 
6)  Verify the Service Application.
Get-SPServiceApplication | Select Name

5)  Create the Service Application Proxy and assign it to the Service Application.
$SvcAppProxy = New-SPVisioServiceApplicationProxy -ServiceApplication SvcApp_SPVisioServiceApplication_01 -Name "SvcApp_SPVisioServiceApplication_01_Proxy_01"

7)  Verify Service Application Proxy.
Get-SPServiceApplicationProxy | Select Name



References

Microsoft TechNet (February, 2014).  New-SPVisioServiceApplication.  Retrieved March 27, 2014 from http://technet.microsoft.com/en-us/library/ff608096%28v=office.15%29.aspx

Microsoft TechNet (February, 2014).  New-SPVisioServiceApplicationProxy.  Retrieved March 27, 2014 from http://technet.microsoft.com/en-us/library/ff608020%28v=office.15%29.aspx

SharePoint 2013: How to Configure Work Management Service Application using PowerShell

Last Updated March 28, 2014



Description

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

Solution

1)  Document the Naming Convention

Document a naming convention for each of the Work Management 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_SPWorkManagementServiceApplication_01

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.
$SvcAppPool02 = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_02"

5)  Create the Service Application and assign it to the Application Pool.
$SvcApp = New-SPWorkManagementServiceApplication -ApplicationPool $SvcAppPool02 -Name "SvcApp_SPWorkManagementServiceApplication_01"
 
6)  Verify the Service Application.
PS C:\ Get-SPServiceApplication | Select Name



References

Microsoft TechNet (February, 2014).  New-SPWorkManagementServiceApplication.  Retrieved March 27, 2014 from http://technet.microsoft.com/en-us/library/fp161254%28v=office.15%29.aspx

SharePoint 2013: Web Application General Settings: Error, Something Went Wrong...

Description

When attempting to modify the Web Application General Settings of a particular Web Application, an error occurs and it is not possible to view the Web Application General Settings page in Central Administration.

Error:  Sorry, something went wrong.  Updates are currently disallowed on GET requests.  To allow updates on a GET, set the 'AllowUnsafeUpdates' property on SPWeb.

Solution

1.  Open the SharePoint Management Shell

2.  Type $WebApp = Get-SPWebApplication http://host.domain.com and press Enter

3.  Type $WebApp.HttpThrottleSettings and press Enter

4.  Type  $WebApp.Update() and Press Enter

5.  Attempt to open the Web Application General Settings from Central Administration.  The page should work at this point.



References

Microsoft TechNet (July, 2012).  Get-SPWebApplication.  Retrieved February 12, 2014 from http://technet.microsoft.com/en-us/library/ff607562.aspx

SharePoint 2013: How to Rename the Search Service Application Using PowerShell

Description

This post explains how to change the name of the Enterprise Search Service Application using PowerShell.


Key Words
PowerShell, Enterprise Search Service Application.


Solution

1.  Set a variable

$SvcAppSearch = Get-SPEnterpriseSearchServiceApplication


2.  Verify the current name

$SvcAppSearch.name


3.  Change the name

$SvcAppSearch.name = "SPEnterpriseSearchServiceApplicationNewName"


4.  Update

$SvcAppSearch.Update()


5.  Verify the new name in PowerShell

Get-SPEnterpriseSearchServiceApplication


6.  Run IIS Reset on the Web server which is hosting Central Administration


7.  Verify the new name in Central Administration

Central Administration, Application Management, Manage Service Applications


References

Microsoft TechNet (2013).  Get-SPEnterpriseSearchServiceApplication.  Retrieved January 29, 2014 from http://technet.microsoft.com/en-us/library/ff608050.aspx

SharePoint 2013: How to Configure the Search Service Application using PowerShell

Description

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

In this example, there is one Database Server (SERVER01), one Web Server (SERVER03), and one Application Server (SERVER04).


Solution

This solution is for a small farm environment that has one Database Server, one Web Server, and one Application Server.  The steps below will result in a complete Search Topology. 

The steps provided do not represent an automated script that you would copy and paste into a window and run all at once.  Instead, the steps are intended to be run manually, one at a time, in the PowerShell window. The post is written this way on purpose and provides a way to step through each cmdlet one at a time.

If you have a different server topology or if you would prefer a fully automated script to provision the Search Service Application, then I recommend that you look at the References section and possibly utilize one of the more sophisticated examples that exist in the community knowledge base.



Before Starting...

Ensure that the Service Account to be used for the Service Application Pool exists and has been registered in Central Administration as a Managed Account

Ensure that the Host Controller Service in Central Administration is registered under a Service Account that has adequate permissions to activate the Search Topology (e.g. Farm Account)


1.  Prepare the PowerShell Session
 
Open the PowerShell window as Administrator.

Clear-Host

Set-ExecutionPolicy unrestricted
Respond Y to confirm

Get-PSSnapin -name Microsoft.SharePoint.PowerShell -EA SilentlyContinue


2.  Determine Naming Convention and Set Initial Variables

Set the Variables

$Svr01 = "SERVER01"
$Svr03 = "SERVER03"
$Svr04 = "SERVER04"
$SvcAppPl03 = "SvcApp_SPServiceApplicationPool_03"
$SvcAppSrch = "SvcApp_SPEnterpriseSearchServiceApplication_01"
$SvcAppSrchPrxy = "SvcApp_SPEnterpriseSearchServiceApplication_01_Proxy_01"
$SvcAppDBSvr = "SERVER01"
$SvcAppDB = "SvcApp_SPEnterpriseSearchServiceApplication_01_DB_01"
$SvcAppSrchAdmnCmp = $SvcAppSrch | Get-SPEnterpriseSearchAdministrationComponent
$ESSI03 = Get-SPEnterpriseSearchServiceInstance -Identity "SERVER03"
$ESSI04  = Get-SPEnterpriseSearchServiceInstance -Identity "SERVER04"
$QSSN03 = Get-SPEnterpriseSearchQueryAndSiteSettingsServiceInstance -Identity "SERVERN03"
$QSSN04 = Get-SPEnterpriseSearchQueryAndSiteSettingsServiceInstance -Identity "SERVERN04"
$IndexLocP = "I:\IndexPrimary"
$IndexLocR = "I:\IndexReplica"


3.  Start the Search Service Instances

Start-SPEnterpriseSearchServiceInstance -Identity $Svr03

Start-SPEnterpriseSearchServiceInstance -Identity $Svr04


4.  Start the Query and Site Settings Service Instances

Start-SPEnterpriseSearchQueryAndSiteSettingsServiceInstance -identity $QSSN03

Start-SPEnterpriseSearchQueryAndSiteSettingsServiceInstance -identity $QSSN04


5.  Create the Search Service Application

New-SPEnterpriseSearchServiceApplication -Name $SvcAppSrch -ApplicationPool $SvcAppPl03 -AdminApplicationPool $SvcAppPl03 -DatabaseName $SvcAppDB -DatabaseServer $SvcAppDBSvr


6.  Set the Search Admin Component

Set-SPEnterpriseSearchAdministrationComponent -SearchServiceInstance $Svr04


7.  Create and Configure Search Topology 02

$SrchTop01 = Get-SPEnterpriseSearchTopology -SearchApplication $SvcAppSrch

$SrchTop02 = New-SPEnterpriseSearchTopology -SearchApplication $SvcAppSrch -Clone -SearchTopology $SrchTop01


8.  Create the Search Admin Component

New-SPEnterpriseSearchAdminComponent –SearchTopology $SrchTop02 -SearchServiceInstance $Svr04


9.  Create Search Content Processing Components

New-SPEnterpriseSearchContentProcessingComponent –SearchTopology $SrchTop02 -SearchServiceInstance $Svr04

New-SPEnterpriseSearchContentProcessingComponent –SearchTopology $SrchTop02 -SearchServiceInstance $Svr03


10.  Create Analytics Processing Components

New-SPEnterpriseSearchAnalyticsProcessingComponent –SearchTopology $SrchTop02 -SearchServiceInstance $Svr04

New-SPEnterpriseSearchAnalyticsProcessingComponent –SearchTopology $SrchTop02 -SearchServiceInstance $Svr03


11.  Create Search Crawl Components

New-SPEnterpriseSearchCrawlComponent –SearchTopology $SrchTop02 -SearchServiceInstance $Svr04

New-SPEnterpriseSearchCrawlComponent –SearchTopology $SrchTop02 -SearchServiceInstance $Svr03


12.  Create Search Query Processing Components

New-SPEnterpriseSearchQueryProcessingComponent –SearchTopology $SrchTop02 -SearchServiceInstance $Svr04

New-SPEnterpriseSearchQueryProcessingComponent –SearchTopology $SrchTop02 -SearchServiceInstance $Svr03


13.  Create and Assign Index Partitions

New-SPEnterpriseSearchIndexComponent –SearchTopology $SrchTop02 -SearchServiceInstance $Svr04 -RootDirectory $IndexLocP -IndexPartition 0

New-SPEnterpriseSearchIndexComponent –SearchTopology $SrchTop02 -SearchServiceInstance $Svr03 -RootDirectory $IndexLocR -IndexPartition 0

New-SPEnterpriseSearchIndexComponent –SearchTopology $SrchTop02 -SearchServiceInstance $Svr03 -RootDirectory $IndexLocP -IndexPartition 1

New-SPEnterpriseSearchIndexComponent –SearchTopology $SrchTop02 -SearchServiceInstance $Svr04 -RootDirectory $IndexLocR -IndexPartition 1


14.  Activate Search Topology 02

Set-SPEnterpriseSearchTopology -Identity $SrchTop02


15.  Remove Search Topology 01

$SrchTop01 = Get-SPEnterpriseSearchTopology -SearchApplication $SvcAppSrch | where {($_.State) -eq "Inactive"}

Remove-SPEnterpriseSearchTopology -Identity $SrchTop01 -Confirm:$false


16.  Create Search Service Application Proxy

$SvcAppSrchPrxy = New-SPEnterpriseSearchServiceApplicationProxy -Name "SvcApp_SPEnterpriseSearchServiceApplication_01_Proxy_01" -SearchApplication $SvcAppSrch



Key Words
Search Service, Search Service Application, Search Topology.



References

ChandrasekarN (February, 2013).  SharePoint 2013 - Configuring Search Service Application and Topology using PowerShell.  Retrieved January 29, 2014 from http://blogs.msdn.com/b/chandru/archive/2013/02/19/sharepoint-2013-configuring-search-service-application-and-topology-using-powershell.aspx

Earp, S. (September, 2013).  Configuring SharePoint 2013 Search with PowerShell.  Retrieved January 27, 2014 from http://blogs.technet.com/b/ptsblog/archive/2013/09/19/configuring-sharepoint-2013-search-with-powershell.aspx

Harbar, S. (July, 2012).  Multi Tenancy with SharePoint 2013: What’s new and changed.  Retrieved January 29, 2014 from http://www.harbar.net/articles/sp2013mt.aspx

Klindt, T. (December, 2012).  Create SharePoint 2013 Search service application with PowerShell.  Retrieved January 29, 2014 from http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=378

Microsoft TechNet (2013).  Create and configure a Search service application in SharePoint Server 2013.  Retrieved January 27, 2014 from http://technet.microsoft.com/en-us/library/gg502597.aspx

Microsoft TechNet (2013).  Get-SPSearchService.  Retrieved January 27, 2014 from http://technet.microsoft.com/en-us/library/ee620539(v=office.14).aspx

Microsoft TechNet (2013).  Get-SPEnterpriseSearchServiceApplication.  Retrieved January 27, 2014 from http://technet.microsoft.com/en-us/library/ff608050.aspx

Microsoft TechNet (2013).  Get-SPEnterpriseSearchServiceInstance.  Retrieved January 27, 2014 from http://technet.microsoft.com/en-us/library/ff607740.aspx

Microsoft TechNet (2013).  Get-SPEnterpriseSearchTopology.  Retrieved January 27, 2014 from http://technet.microsoft.com/en-us/library/jj219578.aspx

Microsoft TechNet (2013).  Get-SPEnterpriseSearchQueryAndSiteSettingsServiceInstance.  Retrieved January 27, 2014 from http://technet.microsoft.com/en-us/library/ff608115.aspx

Microsoft TechNet (2013).  New-SPEnterpriseSearchServiceApplication.  Retrieved January 27, 2014 from http://technet.microsoft.com/en-us/library/ff607751.aspx

Microsoft TechNet (2013).  New-SPEnterpriseSearchServiceApplicationProxy.  Retrieved January 27, 2014 from http://technet.microsoft.com/en-us/library/ff607722.aspx

Microsoft TechNet (2013).  Set-SPEnterpriseSearchServiceApplication.  Retrieved January 27, 2014 from http://technet.microsoft.com/en-us/library/ff607974.aspx

Microsoft TechNet (2013).  Set-SPEnterpriseSearchTopology.  Retrieved January 27, 2014 from http://technet.microsoft.com/en-us/library/jj219653.aspx

Microsoft TechNet (2013).  Start-SPEnterpriseSearchQueryAndSiteSettingsServiceInstance.   Retrieved January 27, 2014 from http://technet.microsoft.com/en-us/library/ff607759.aspx

Microsoft TechNet (2013).  Start-SPEnterpriseSearchServiceInstance.  Retrieved January 27, 2014 from http://technet.microsoft.com/en-us/library/ff607852.aspx

Microsoft TechNet (2013).  Remove-SPEnterpriseSearchTopology.  Retrieved January 27, 2014 from http://technet.microsoft.com/en-us/library/jj219505.aspx

Ravikanth (April, 2013).  Creating and configuring a SharePoint 2013 search service application.  Retrieved January 29, 2014 from http://www.powershellmagazine.com/2013/04/29/creating-and-configuring-a-sharepoint-2013-search-service-application/

SharePoint 2013: How to Configure the Machine Translation Service Application using PowerShell

Description

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


Solution

1)  Document the Naming Convention
Determine a naming convention for each of the Service Application components.  Document the naming convention.

Application Pool: SvcApp_SPServiceApplicationPool_01
Application Pool Service Account:  Domain\SvcAccount
Application:  SvcApp_SPPerformancePointServiceApplication_01

2)  Prepare the Application Pool / Service Account
Example: Subscription Settings Application Pool: SvcApp_SPServiceApplicationPool_01 Application Pool Service Account:  Domain\SvcAccount

A) If you are using an existing application pool:
You do not need to create a Service Account nor an Application Pool.  Note the names of each.

Verify Application Pool.
Get-SPServiceApplicationPool | Select Name

Get the existing Application Pool.
$SvcAppPool = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_01"

B) If you are creating a new application pool:
Determine which service account you will use to run the application pool that will be assigned to the.  If you need to, create and register a service account to run the Subscription Settings Service Application.

Create the Service Application Pool and register it to the Service Account.
$SvcAppPool = New-SPServiceApplicationPool -Name "SvcApp_SPServiceApplicationPool_01"$AppPool = New-SPServiceApplicationPool -Account (Get-SPManagedAccount Domain\SvcAccount)

Verify Application Pool.
Get-SPServiceApplicationPool | Select Name

Get the existing Application Pool.
$SvcAppPool = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_01"

3)  Open the SharePoint 2013 Management Shell as Administrator.

4)  Create the Service Application and assign it to the Application Pool.
$SvcApp = New-SPTranslationServiceApplication –ApplicationPool $SvcAppPool -Name "SvcApp_SPTranslationServiceApplication_01" -DatabaseName "SvcApp_SPTranslationServiceApplication_01_DB_01" -DatabaseServer "SQL Alias Name"

Verify Service Application.
Get-SPServiceApplication | Select Name

5)  Create the Service Application Proxy and assign it to the Service Application.
$SvcAppProxy = New-SPTranslationServiceApplicationProxy -Name "SvcApp_SPTranslationServiceApplication_01_Proxy_01" -ServiceApplication $SvcApp

Verify Service Application Proxy
Get-SPServiceApplicationProxy | Select Name


Notes
This Service Application does have a database associated with it.

These steps will result in a redundant Proxy for the Service Application.  One can be deleted.


References

Microsoft TechNet (2012).  New-SPTranslationServiceApplication.  Retrieved January 23, 2014 from http://technet.microsoft.com/en-us/library/jj219712.aspx.

Microsoft TechNet (2012).  New-SPTranslationServiceApplicationProxy.  Retrieved January 23, 2014 from http://technet.microsoft.com/en-us/library/jj219763.aspx.

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

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

SharePoint 2013: How to Configure the PerformancePoint Service Application using PowerShell

Description

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


Solution

1)  Document the Naming Convention
Determine a naming convention for each of the Service Application components.  Document the naming convention.

Application Pool: SvcApp_SPServiceApplicationPool_01
Application Pool Service Account:  Domain\SvcAccount
Application:  SvcApp_SPPerformancePointServiceApplication_01

2)  Prepare the Application Pool / Service Account
Example: Subscription Settings Application Pool: SvcApp_SPServiceApplicationPool_01 Application Pool Service Account:  Domain\SvcAccount

A) If you are using an existing application pool:
You do not need to create a Service Account nor an Application Pool.  Note the names of each.

Verify Application Pool.
Get-SPServiceApplicationPool | Select Name

Get the existing Application Pool.
$SvcAppPool = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_01"

B) If you are creating a new application pool:
Determine which service account you will use to run the application pool that will be assigned to the.  If you need to, create and register a service account to run the Subscription Settings Service Application.

Create the Service Application Pool and register it to the Service Account.
$SvcAppPool = New-SPServiceApplicationPool -Name "SvcApp_SPServiceApplicationPool_01"$AppPool = New-SPServiceApplicationPool -Account (Get-SPManagedAccount Domain\SvcAccount)

Verify Application Pool.
Get-SPServiceApplicationPool | Select Name

Get the existing Application Pool.
$SvcAppPool = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_01"

3)  Open the SharePoint 2013 Management Shell as Administrator.

4)  Create the Service Application and assign it to the Application Pool.
$SvcApp = New-SPPerformancePointServiceApplication –ApplicationPool $SvcAppPool -Name "SvcApp_SPPerformancePointServiceApplication_01" -DatabaseName "SvcApp_SPPerformancePointServiceApplication_01_DB_01" -DatabaseServer "SQL Alias Name"

Verify Service Application.
Get-SPServiceApplication | Select Name

5)  Create the Service Application Proxy and assign it to the Service Application.
$SvcAppProxy = New-SPPerformancePointServiceApplicationProxy -Name "SvcApp_SPPerformancePointServiceApplication_01_Proxy_01" -ServiceApplication $SvcApp

Verify Service Application Proxy
Get-SPServiceApplicationProxy | Select Name


Notes
This Service Application does have a database associated with it.


References

Microsoft TechNet (2012).  New-SPPerformancePointServiceApplication.  Retrieved January 23, 2014 from http://technet.microsoft.com/en-us/library/ff608122.aspx.

Microsoft TechNet (2012).  New-SPPerformancePointServiceApplicationProxy.  Retrieved January 23, 2014 from http://technet.microsoft.com/en-us/library/ff608135.aspx.

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

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

SharePoint 2013: How to Configure the Word Automation Service Application using PowerShell

Last Updated March 28, 2014


Description

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


Solution

1)  Document the Naming Convention

Determine a naming convention for each of the Word Automation Service Application components.  Document the naming convention.

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_SPWordConversionServiceApplication_01
Service Application Proxy:  SvcApp_SPWordConversionServiceApplication_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)  Get the existing Application Pool.
$SvcAppPool02 = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_02"

5)  Open the SharePoint 2013 Management Shell as Administrator.

6)  Create the Service Application and assign it to the Application Pool.
$SvcApp = New-SPWordConversionServiceApplication –ApplicationPool $SvcAppPool02 -Name "SvcApp_SPWordConversionServiceApplication_01" -DatabaseName "SvcApp_SPWordConversionServiceApplication_01_DB_01" -DatabaseServer "SQL Alias Name"

The Proxy is created when the New Service Application cmdlet is run.  It does not appear that the name of the Proxy may be set or changed independently for this Service Application.

7)  Verify Service Application.
Get-SPServiceApplication | Select Name

8)  Verify Service Application Proxy
Get-SPServiceApplicationProxy | Select Name



References

Microsoft TechNet (2012).  New-SPWordConversionServiceApplication.  Retrieved January 23, 2014 from http://technet.microsoft.com/en-us/library/ff608091.aspx.

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

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

SharePoint 2013: How to Configure the Excel Service Application using PowerShell

Description

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


Solution

1)  Document the Naming Convention
Determine a naming convention for each of the Service Application components.  Document the naming convention.

Application Pool: SvcApp_SPServiceApplicationPool_01
Application Pool Service Account:  Domain\SvcAccount
Application:  SvcApp_SPExcelServiceApplication_01

2)  Prepare the Application Pool / Service Account
Example: Subscription Settings Application Pool: SvcApp_SPServiceApplicationPool_01 Application Pool Service Account:  Domain\SvcAccount

A) If you are using an existing application pool:
You do not need to create a Service Account nor an Application Pool.  Note the names of each.

Verify Application Pool.
Get-SPServiceApplicationPool | Select Name

Get the existing Application Pool.
$SvcAppPool = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_01"

B) If you are creating a new application pool:
Determine which service account you will use to run the application pool that will be assigned to the.  If you need to, create and register a service account to run the Subscription Settings Service Application.

Create the Service Application Pool and register it to the Service Account.
$SvcAppPool = New-SPServiceApplicationPool -Name "SvcApp_SPServiceApplicationPool_01"$AppPool = New-SPServiceApplicationPool -Account (Get-SPManagedAccount Domain\SvcAccount)

Verify Application Pool.
Get-SPServiceApplicationPool | Select Name

Get the existing Application Pool.
$SvcAppPool = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_01"

3)  Open the SharePoint 2013 Management Shell as Administrator.

4)  Create the Service Application and assign it to the Application Pool.
$SvcApp = New-SPExcelServiceApplication –ApplicationPool $SvcAppPool -Name "SvcApp_New-SPExcelServiceApplication_01"

Verify Service Application.
Get-SPServiceApplication | Select Name

Verify Service Application Proxy
Get-SPServiceApplicationProxy | Select Name


Notes
The Proxy is created when the New Service Application cmdlet is run.  It does not appear that the name of the Proxy may be set or changed independently for this Service Application. 


References

Microsoft TechNet (2012).  New-SPExcelServiceApplication.  Retrieved January 22, 2014 from http://technet.microsoft.com/en-us/library/ff607809.aspx.

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

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

SharePoint 2013: How to Configure the Access Service Application using PowerShell

Description

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


Solution

1)  Document the Naming Convention
Determine a naming convention for each of the Service Application components.  Document the naming convention.

Application Pool: SvcApp_SPServiceApplicationPool_01
Application Pool Service Account:  Domain\SvcAccount
Application:  SvcApp_SPAccessServiceApplication_01

2)  Prepare the Application Pool / Service Account
Example: Subscription Settings Application Pool: SvcApp_SPServiceApplicationPool_01 Application Pool Service Account:  Domain\SvcAccount

A) If you are using an existing application pool:
You do not need to create a Service Account nor an Application Pool.  Note the names of each.

Verify Application Pool.
Get-SPServiceApplicationPool | Select Name

Get the existing Application Pool.
$SvcAppPool = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_01"

B) If you are creating a new application pool:
Determine which service account you will use to run the application pool that will be assigned to the.  If you need to, create and register a service account to run the Subscription Settings Service Application.

Create the Service Application Pool and register it to the Service Account.
$SvcAppPool = New-SPServiceApplicationPool -Name "SvcApp_SPServiceApplicationPool_01"$AppPool = New-SPServiceApplicationPool -Account (Get-SPManagedAccount Domain\SvcAccount)

Verify Application Pool.
Get-SPServiceApplicationPool | Select Name

Get the existing Application Pool.
$SvcAppPool = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_01"

3)  Open the SharePoint 2013 Management Shell as Administrator.

4)  Create the Service Application and assign it to the Application Pool.
$SvcApp = New-SPAccessServiceApplication –ApplicationPool $SvcAppPool -Name "SvcApp_SPAccessServiceApplication_01"

Verify Service Application.
Get-SPServiceApplication | Select Name

Verify Service Application Proxy
Get-SPServiceApplicationProxy | Select Name


Notes
The Proxy is created when the New Service Application cmdlet is run.  It does not appear that the name of the Proxy may be set or changed independently for this Service Application.


References

Microsoft TechNet (2012).  New-SPAccessServiceApplication.  Retrieved January 22, 2014 from http://technet.microsoft.com/en-us/library/ff607785.aspx.

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

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

SharePoint 2013: How to Configure the Metadata Service Application using PowerShell

Description

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


Solution

1)  Document the Naming Convention
Determine a naming convention for each of the Service Application components.  Document the naming convention.

Application Pool: SvcApp_SPServiceApplicationPool_01
Application Pool Service Account:  Domain\SvcAccount
Application:  SvcApp_SPMetadataServiceApplication_01
Proxy:  SvcApp_SPMetadataServiceApplication_01_Proxy_01  
Database: SvcApp_SPMetadataServiceApplication_01_DB_01

2)  Prepare the Application Pool / Service Account
Example: Subscription Settings Application Pool: SvcApp_SPServiceApplicationPool_01 Application Pool Service Account:  Domain\SvcAccount

A) If you are using an existing application pool:
You do not need to create a Service Account nor an Application Pool.  Note the names of each.

Verify Application Pool.
Get-SPServiceApplicationPool | Select Name

Get the existing Application Pool.
$SvcAppPool = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_01"

B) If you are creating a new application pool:
Determine which service account you will use to run the application pool that will be assigned to the.  If you need to, create and register a service account to run the Subscription Settings Service Application.

Create the Service Application Pool and register it to the Service Account.
$SvcAppPool = New-SPServiceApplicationPool -Name "SvcApp_SPServiceApplicationPool_01"$AppPool = New-SPServiceApplicationPool -Account (Get-SPManagedAccount Domain\SvcAccount)

Verify Application Pool.
Get-SPServiceApplicationPool | Select Name

Get the existing Application Pool.
$SvcAppPool = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_01"

3)  Open the SharePoint 2013 Management Shell as Administrator.

4)  Create the Service Application and assign it to the Application Pool.
$SvcApp = New-SPMetadataServiceApplication –ApplicationPool $SvcAppPool -Name "SvcApp_SPMetadataServiceApplication_01" -DatabaseName "SvcApp_SPMetadataServiceApplication_01_DB_01"

Verify Service Application.
Get-SPServiceApplication | Select Name

5)  Create the Service Application Proxy and assign it to the Service Application.
$SvcAppProxy = New-SPMetadataServiceApplicationProxy -Name "SvcApp_SPMetadataServiceApplication_01_Proxy_01" -ServiceApplication $SvcApp

Verify Service Application Proxy
Get-SPServiceApplicationProxy | Select Name


References

Microsoft TechNet (2012).  New-SPMetadataServiceApplication.  Retrieved January 22, 2014 from http://technet.microsoft.com/en-us/library/ff607557.aspx.

Microsoft TechNet (2012).  New-SPMetadataServiceApplicationProxy.  Retrieved January 22, 2014 from http://technet.microsoft.com/en-us/library/ff608097.aspx.

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

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

SharePoint 2013: How to Configure the Business Data Catalog Service Application using PowerShell

Description

This post describes how to configure the SharePoint Server 2013 Business Data Catalog Service Application using PowerShell.


Solution

1)  Document the Naming Convention
Determine a naming convention for each of the Service Application components.  Document the naming convention.

Application Pool: SvcApp_SPServiceApplicationPool_01
Application Pool Service Account:  Domain\SvcAccount
Application:  SvcApp_SPBusinessDataCatalogServiceApplication_01
Proxy:  SvcApp_SPBusinessDataCatalogServiceApplication_01_Proxy_01  
Database: SvcApp_SPBusinessDataCatalogServiceApplication_01_DB_01

2)  Prepare the Application Pool / Service Account
Example: Subscription Settings Application Pool: SvcApp_SPServiceApplicationPool_01 Application Pool Service Account:  Domain\SvcAccount

A) If you are using an existing application pool:
You do not need to create a Service Account nor an Application Pool.  Note the names of each.

Verify Application Pool.
Get-SPServiceApplicationPool | Select Name

Get the existing Application Pool.
$SvcAppPool = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_01"

B) If you are creating a new application pool:
Determine which service account you will use to run the application pool that will be assigned to the.  If you need to, create and register a service account to run the Subscription Settings Service Application.

Create the Service Application Pool and register it to the Service Account.
$SvcAppPool = New-SPServiceApplicationPool -Name "SvcApp_SPServiceApplicationPool_01"$AppPool = New-SPServiceApplicationPool -Account (Get-SPManagedAccount Domain\SvcAccount)

Verify Application Pool.
Get-SPServiceApplicationPool | Select Name

Get the existing Application Pool.
$SvcAppPool = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_01"

3)  Open the SharePoint 2013 Management Shell as Administrator.

4)  Create the Service Application and assign it to the Application Pool.
$SvcApp = New-SPBusinessDataCatalogServiceApplication –ApplicationPool $SvcAppPool  -Name "SvcApp_ SPBusinessDataCatalogServiceApplication _01" -DatabaseName "SvcApp_ SPBusinessDataCatalogServiceApplication _01_DB_01"

Verify Service Application.
Get-SPServiceApplication | Select Name

5)  Create the Service Application Proxy and assign it to the Service Application. 
$SvcAppProxy = New-SPBusinessDataCatalogServiceApplicationProxy -Name "SvcApp_SPBusinessDataCatalogServiceApplication_01_Proxy_01" -ServiceApplication $SvcApp

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


References

Microsoft TechNet (2012).  New-SPBusinessDataCatalogServiceApplication.  Retrieved January 22, 2014 from http://technet.microsoft.com/en-us/library/ff607899.aspx.

Microsoft TechNet (2012).  New-SPBusinessDataCatalogServiceApplicationProxy.  Retrieved January 22, 2014 from http://technet.microsoft.com/en-us/library/ff607952.aspx.

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

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

SharePoint 2013: How to Configure the Usage Service Application using PowerShell

Last Updated March 28, 2014  


Description

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


Solution

1)  Plan and Document the Naming Convention.
Document a naming convention for each of the 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_SPUsageApplication_01
Service Application Database:  SvcApp_SPUsageApplication_01_DB_01 
Service Application Proxy:  SvcApp_SPUsageApplication_01_Proxy_01

2)  Open the SharePoint 2013 Management Shell. 

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

4)  Get the existing Application Pool.
$SvcAppPool02 = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_02"

5)  Create the Service Application and assign it to the Application Pool.
$SvcApp = New-SPUsageApplication –Name “SvcApp_SPUsageApplication_01” -DatabaseName "SvcApp_SPUsageApplication_01_DB_01" –DatabaseServer “SQL Alias Name” 

The Proxy is created automatically when the New Service Application cmdlet is run.  It does not appear that the name of the Proxy may be set or changed independently for this Service Application at the time of creation.

6)  Verify Service Application.
Get-SPServiceApplication | Select Name 

7) Verify Service Application Proxy.
Get-SPServiceApplicationProxy | Select Name   

8) Get the Usage and Health Data Collection Proxy.
$SvcAppProxy = Get-SPServiceApplicationProxy | Where {$_.TypeName -like “Usage and Health*”}

9) Start the Usage and Health Data Collection Proxy.
$SvcAppProxy.Provision()

References

Microsoft TechNet (2012).  New-SPUsageApplication.  Retrieved January 22, 2014 from http://technet.microsoft.com/en-us/library/ff607699.aspx.

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

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

SharePoint 2013: How to Configure Secure Store Service Application using PowerShell

Last Updated March 28, 2014

Description

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

Solution

1)  Document the Naming Convention
Determine a naming convention for each of the Secure Store Service Application components.  Document the naming convention.

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_SPSecureStoreServiceApplication_01
Database: SvcApp_SPSecureStoreServiceApplication_01_DB_01

Service Application Proxy:  SvcApp_SPSecureStoreServiceApplication_01_Proxy_01

2)  Open the SharePoint 2013 Management Shell as Administrator.

3)  Start the Secure Store Service.
Get-SPServiceInstance | Where {$_.TypeName -like "Secure Store Service"}

Use the Get-SPServiceInstance cmdlet to get the ID Numbers of the SPServiceInstance(s).  Once you have the ID Numbers, use the numbers to start each SPServiceInstance.  Once fully started, the status of each will show as "Online".

Example:
Start-SPServiceInstance 67877d63-bff4-4521-867a-ef4979ba07ce

Start-SPServiceInstance IDNumber1
Start-SPServiceInstance IDNumber2

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 Secure Store Service Application.  Specify the Application Pool, the AuditingEnabled setting, the Service Application Name, the Database Name, and the Database Server Name.

$SvcApp = New-SPSecureStoreServiceApplication -ApplicationPool $SvcAppPool –AuditingEnabled:$false -Name "SvcApp_SPSecureStoreServiceApplication_01" -DatabaseName "SvcApp_SPSecureStoreServiceApplication_01_DB_01" -DatabaseServer "SQL Server Alias"
 
6)  Verify the Service Application.
Get-SPServiceApplication | Select Name

7)  Create the Service Application Proxy and assign it to the Service Application.
$SvcAppProxy = New-SPSecureStoreServiceApplicationProxy -Name "SvcApp_SPSecureStoreServiceApplication_01_Proxy_01" -ServiceApplication $SvcApp

8)  Verify Service Application Proxy.
Get-SPServiceApplicationProxy | Select Name

References

Farid, S. (2011).  Configure Secure Store Service using PowerShell.  Retrieved January 22, 2014 from http://samirfarid.wordpress.com/2011/11/28/configure-secure-store-service-using-powershell.

Microsoft TechNet (2014).  Configure the Secure Store Service in SharePoint 2013.   Retrieved January 22, 2014 from http://technet.microsoft.com/en-us/library/ee806866.aspx.

Microsoft TechNet (2014).  New-SPSecureStoreServiceApplication.  Retrieved January 22, 2014 from http://technet.microsoft.com/en-us/library/ff608083.aspx.

Microsoft TechNet (2014).  New-SPSecureStoreServiceApplicationProxy.  Retrieved January 22, 2014 from http://technet.microsoft.com/en-us/library/ff607856.aspx.

Microsoft TechNet (2014).  Secure Store Service cmdlets in SharePoint 2013.  Retrieved January 22, 2014 from http://technet.microsoft.com/en-us/library/ee906549.aspx.

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

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