Use Windows PowerShell cmdlets to manage Access Services in SharePoint Server 2013


Applies to: SharePoint Server 2013 Enterprise

Topic Last Modified: 2015-03-09

Summary:Learn about the Windows PowerShell cmdlets that you can use to manage Microsoft Access service applications in SharePoint Server 2013.

Access Services is a service in SharePoint Server 2013 that lets an administrator view, edit, and configure a Microsoft Access service application within a Web browser.

All Access Services settings support backup and recovery, regardless of whether there is a UI setting in Central Administration. However, backup and recovery only apply to service-level and administrative-level settings; end-user content from the Access application is not backed up as part of this process.

Access Services has Windows PowerShell functionality that you can use to provision the service or provision a new instance that uses settings from a previous backup; configure and manage macro and query setting; manage and configure session management; and configure all the global settings of the service.

All cmdlets on this page are new to SharePoint Server 2013.

Index of Windows PowerShell cmdlets for SharePoint 2013 includes a complete list of all cmdlets in SharePoint 2013.


Cmdlet name Description


Returns an Access Services application or a collection of Access Services applications.


Returns an Access Services database or a collection of Access Services databases.


Returns the settings for all application servers.


Returns the settings for all application server groups.


Returns the mapping from a source package type to the database server group.


Creates a new instance of an Access Services application in SharePoint Server 2013.


Adds a new SQL Server database to the list of servers.


Removes the specified database server.


Resets the passwords for all logons for user application databases.


Sets global properties of an existing Access Services application in SharePoint Server 2013.


Specifies whether or not a database in SQL Server is available.


Sets server group mappings.