dear all,

I have enabled contacts database using Access Service application in SharePoint 2010.

I have enabled access services in the server services tab.

Secondly I have enabled the access service application with a separate AD user account for this service application.

When I try to open the contacts database. I get the following below error.

I checked the ULS log and found these- but unable to make out.

05/28/2015 16:52:05.43 w3wp.exe (0x2B64) 0x2054 SharePoint Server Logging Correlation Data xmnv Medium AccSrv Application URL=http://intanet.co.in/Test/test 1bd46ced-87d6-443d-af84-fdfaf62660d6

in some sites they have mentioned that we need to give or specify the address of the server.

Can somebody give inputs?

thanks

sathya

Hi Sathya,

For this issue, I suggest you follow the troubleshooting steps as below:

1. Your SharePoint 2010 Farm is running with an Enterprise license and is patched to SP1 or above;

2. Access Services is configured as a Service Application within your Farm and the service itself is set to Running;

3. Either the SQL Server Reporting Service 2012 Service Application, or the Reporting Services -Add-in for SharePoint Integrated mode has been applied;

4. The SharePoint State Service has been configured (this is a Powershell Only Service Application in terms of provisioning); http://technet.microsoft.com/en-us/library/ee704548(v=office.14).aspx  

5. You have created either a Web, Contacts or Project database using the standard SharePoint template;

Here is a blog which would provide more information about how to troubleshooting this issue for your reference:

https://adammcewen.wordpress.com/2013/02/27/issues-when-deploying-access-services-in-sharepoint-2010/

Thanks 

Patrick Liang

Dear Patrick,

The above steps are really fantastic and very useful. This give me more confidence levels - that I will complete the project.

I had checked the links and stuck with one problem.

I had created the database - initialized to the service application.

Somehow I am getting the error in the event log as

Log Name:      Application
Source:        Microsoft-SharePoint Products-SharePoint Foundation
Date:          6/1/2015 5:06:56 PM
Event ID:      3760
Task Category: Database
Level:         Critical
Keywords:     
User:          domain\SPSAccess
Computer:      computer.ifmr.co.in
Description:
SQL Database 'SP2010_Access' on SQL Server instance 'INxxxMS0008' not found. Additional error information from SQL Server is included below.

Cannot open database "SP2010_Access" requested by the login. The login failed.
Login failed for user 'domain\SPSAccess'.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6FB7E0CD-52E7-47DD-997A-241563931FC2}" />
    <EventID>3760</EventID>
    <Version>14</Version>
    <Level>1</Level>
    <Task>3</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime="2015-06-01T11:36:56.718870600Z" />
    <EventRecordID>1246860</EventRecordID>
    <Correlation ActivityID="{63F00B91-4CA5-46A9-8AD9-12BF673773D4}" />
    <Execution ProcessID="7596" ThreadID="9108" />
    <Channel>Application</Channel>
    <Computer>computer.ifmr.co.in</Computer>
    <Security UserID="S-1-5-21-3939489263-3197679683-2137223578-10512" />
  </System>
  <EventData>
    <Data Name="string0">'SP2010_Access' </Data>
    <Data Name="string1">INMAA3BMS0008</Data>
    <Data Name="string2">Cannot open database 'SP2010_Access' requested by the login. The login failed.
Login failed for user 'domain\SPSAccess'.</Data>
  </EventData>
</Event>

somepart of the eventlog - I edited for hiding the settings.

Do I need to connect the service application using central administration to database or do I need to use the powershell to connect the service application using powershell.

my request here is how do I change the database setting for service application. Here it is showing to a wrong database.

thanks

Sathya

Hi Sathya,

What is the use of this SP2010_Access database?

Is it a database which is specified when creating a service application?

According to the error message, the account which used to enable Access Service Application seems not have sufficient permission to perform some kind of operations, you can try grant the db_owner permission of the corresponding SharePoint Content Database(the web application which you publish the Access database to) to it and make another test again.

Thanks 

Patrick Liang