Revision #5

You are currently reviewing an older revision of this page.
Go to current version
NOTE: This is a stub article. Please add more information as it becomes available.



Overview

Access Services in SharePoint Server 2013 allows people to host Access databases in SharePoint within the context of an Access app. Access apps for SharePoint are new in SharePoint Server 2013 and you will build them using the Access 2013 desktop client.  You can create, edit, and update linked Access 2013 databases and then view them directly from the app.  

You can also use Access Services to view and edit a web database that was created using Access 2010 and SharePoint 2010, and you can republish them to SharePoint Server 2013.  You can't create a web database using Access Services in SharePoint 2013, but you can import Access 2010 web databases into an Access app.

Access apps are SharePoint apps, therefore fo Access Services to run Access app, SharePoint Server 2013 needs to be configured as a SharePoint app server. In addition, Access Services requires SQL Server 2012 to run.

Prerequisites

  • SharePoint Server 2013 installed on a Windows 2008 R2 Server or higher
  • SQL Server 2012 Standard or SQL Server 2012 Enterprise
  • The following SQL Server 2012 Feature Pack Components on the SharePoint server:
    • SQL Server 2012 Local DB
    • SQL Server 2010 Data-Tier Application Framwork
    • SQL Server 2012 Native Client
    • SQL Server 2012 Transact-SQL ScriptDom
    • System CLR Types for SQL Server 2012

 

 

Configure SQL Server 2012

Each Access app creates its own database on SQL Server. In SharePoint  Server 2013, SQL Server 2012 is the only version of SQL Server that can serve as the SharePoint Server 2013 application database server for Access Services. .  For installing SQL Server 2012, refer to the article Installation for SQL Server 2012 .

The following configuration example is based on a previously released white paper,  and describes a  single on-premises Farm setup where the Service Applications and the Configuration Database are stored on the same database server that Access Services uses as its application database server.
 

Required SQL Server 2012 settings for Access apps

  • SQL Instance Feature Selections
    • Database Engine Services
    • Full-Text and Semantic Extractions for Search
    • SQL Management Tools feature ( for troubleshooting)
    • Client Tools connectivity
  • Security Mode = Mixed (SQL Server & Windows Authentication)
  • SA password
  • The SA account running Access Services must have the following roles on the SQL Server Security Logins table:
    • dbcreator
    • securityadmin

To open the SQL Server Security Logins table, open SQL Server Management Studio for the SQL instance. Expand the Server Objects. Under Security, select Logins.


Configure Access Services

Set a new Application Database Server

Create an Access App

 


See Also

Revert to this revision