Wednesday, April 4, 2012

Set up and configure Access Services (SharePoint Server 2010)

 

http://technet.microsoft.com/en-us/library/ee748653.aspx

Access Services in Microsoft SharePoint Server 2010 is a service that allows users to publish an Microsoft Access 2010 Web database to a SharePoint site. When an Access Web database is published to SharePoint Server 2010, a site is created to host the Web database, plus it moves all of the database objects and data to a SharePoint list on that site.

While you do not need the Access client to use the published Web database, the Access client is required to make any changes to the database structure. In addition, a user account is required to use the Web database on SharePoint Server 2010. Anonymous access is not supported

Deploy Access Services

The following steps are needed to deploy Access Services:

  1. Install and configure Microsoft SQL Server 2008 R2 Reporting Services Add-in for SharePoint Technologies 2010 (SSRS).
  2. Create an account in the Active Directory directory service to run the application pool for the Access Services service application.
  3. Register that account as a managed account in SharePoint Server 2010.
  4. Start Access Services.
  5. Create an Access Services service application

To create an Access Services service application

1. On the Central Administration home page, under Application Management, click Manage service applications.

2. On the Manage Service Applications page, click New, and then click Access Services.

3. In the Access Services Application Name section, type Access Services in the text box.

4. Select the Create new application pool option and type AccessServicesAppPool in the Application pool name text box.

5. Select the Configurable option, and from the drop-down list, select CONTOSO\accessapppool.

6. Click OK.

When you get the below error message;

SharePoint 2010, this report failed to load because session state is not turned on.

Use : http://geekdeck.com/sharepoint-2010-this-report-failed-to-load-because-session-state-is-not-turned-on/

The error usually comes when you install SharePoint 2010 in stand alone mode because if you do so the default behavior is that session state for access reports is not enabled and you need to do so. You generally come across this error while creating Contact, Asset and other type of Web Databases.

clip_image001

Enabling Session State for SharePoint 2010 Access Reports:

1) Open SharePoint 2010 Management Shell

2) Type in the following command PS C:\Users\sp> enable-SPSessionStateService

3) You should get the following response:-

cmdlet Enable-SPSessionStateService at command pipeline position 1
Supply values for the following parameters:

4) Type in the Database Name as accessreports (DatabaseName: accessreports) – This will create a new database in SQL names accessreports

5) You will be return to the root path PS C:\Users\sp>

clip_image003

6) Open the normal command prompt and restart the IIS by typing in iisreset

7) Go back to your site and check, Access reports will now be working

1 comment:

  1. Hi Jan,
    Can you help me figure out what is the problem with our setup/configuration? We cannot publish an access database to SharePoint server 2010 as we get this error “An error occurred while initializing access services database.” whenever we try to publish the default contact database. By the way, we are using the single server environment (standalone). If you need more details just let me know. Any help would be appreciated, thanks.

    ReplyDelete