Access Services - can't get it working and I've installed everything FIVE TIMES

Question

I've been trying like a banshee to get Access Services working. I generally know my way around sharepoint.. I just can't for the life of me get this thing working.

I've literally installed SharePoint 2013 in a new environment five times- trying to try different combinations, and I just assume that I'm doing something wrong. I've tried VMs, every time I do this- I put SharePoint on a domain controller.. and the primary logins are all domain admins / enterprise admins.

I see that there's a new whitepaper from Microsoft about this, it was published on 2/7. I definitely have new and interesting information in this article http://www.microsoft.com/en-us/download/details.aspx?id=30445

I really believe that I've tried my best, and this just isn't working!

Here's a previous question from stackoverflow: SharePoint 2013 Access Services Config

I have been using the ULS utility to search for errors.. but now, I just don't get any decent errors, I can't figure it out.

Here is a dump of all of my logs associated with the latest correlationID, can someone look over these and help me to figure out what I should research?

http://accessadp.com/2013/02/15/access-services-latest-uls-error-dump-215/

Answer 1

After sifting through your log dump, here's what stands out at me.

The first errors you encounter start at:

02/15/2013 12:29:26.60 w3wp.exe (0×1024) 0x208C SharePoint Foundation General adyrv High Cannot find site lookup info for request Uri http://win-fdshjv8jiql:32843/86ed9d455deb4308b14ed8f76394e215/AccessService.svc. 8f1bff9b-382b-8022-6d66-ab9bf55589bd

02/15/2013 12:29:26.60 w3wp.exe (0×1024) 0x208C Access Services Host Layer adiqc Medium The current application is null. 8f1bff9b-382b-8022-6d66-ab9bf55589bd

And sort of snowball from there.

A little further down you'll find:

02/15/2013 12:29:26.61 w3wp.exe (0×1024) 0x208C SharePoint Foundation Authentication Authorization agb9s Medium Non-OAuth request. IsAuthenticated=False, UserIdentityName=, ClaimsCount=0 8f1bff9b-382b-8022-6d66-ab9bf55589bd

I've noticed the claims user you're logged in as is not the same as the Windows Identity you're logged in as but there is no identity in the HttpContext:

02/15/2013 12:29:26.63 w3wp.exe (0×1024) 0x208C SharePoint Foundation App Deployment acjjg Medium The current user has System.Threading.Thread.CurrentPrincipal.Identity.Name = 0#.w|mcdba\administrator, System.Security.Principal.WindowsIdentity.GetCurrent().Name = MCDBA\mossfarmadmin, System.Web.HttpContext.Current.User.Identity.Name = . 8f1bff9b-382b-8022-6d66-ab9bf55589bd

Of course the actual error thrown during provisioning is so descriptive...:

02/15/2013 12:29:27.89 w3wp.exe (0x265C) 0x27F8 SharePoint Server Logging Correlation Data xmnv Medium Result=Microsoft.Office.Access.Services.Proxy.AccessServerSessionException: An error has occurred. at Microsoft.Office.Access.Services.Proxy.ServerSession.ExecuteWebMethodCore(WebMethodType webMethodType, WebMethodBehaviorAttribute webMethodBehavior, CommandParameter parameter, CoreWebMethod coreWebMethod) at Microsoft.Office.Access.Services.Proxy.ServerSession.ExecuteWebMethod(WebMethodType webMethodType, WebMethodBehaviorAttribute webMethodBehavior, CommandParameter parameter, CoreWebMethod coreWebMethod) 8f1bff9b-382b-8022-6d66-ab9bf55589bd

Unfortunately I don't have an answer for you, but I would try to log in to the box as the farm admin to perform this action instead of using different accounts. No guarantees, but I hope this helps point you in the right direction.

Answer 2

1. Is the Access service started on at least one server in Manage Services on Server
2. Have you tried the installation on a physical box (non-VM)? Believe it or not, this can have an impact and it will help us narrow it down to a VM setting.
3. What permissions does the App Pool Identity have (database, local)?

Answer 3

One common issue that you might check is whether the SharePoint Web Services application pool is running.

Open IIS Manager and look at the Application Pools. Make sure that application pool isn't stopped.

Answer 4

I'm not sure if this will help but I was successful following this post... Configuring Access Services 2013 on Premises

Answer 5

may be its too late with a new answer, but I only want to share my experience with this error.

I found this question googling exact problem and finally figured out how to solve it. In my situation I've gave securityadmin and dbcreator permissions for my sp_services account, then I decided to create new separate application pool for access services with sp_access account, and forgot to give above permissions for it.

So, to solve error in my case I had to add securityadmin and dbcreator permissions on SQL Server for sp_access (application pool account for access services).

Actual stack trace:

Exception while executing task 583a934b-9538-4107-aa16-f81351fdfe64 of type 
Microsoft.SharePoint.Packaging.SPDatabaseDeploymentGroup in job 
a4ed61c2-c9d6-4ef6-a51b-8d9b26ceb96e for instance c877f325-b0ac-464b-9cc7-5f91474c1291
 sitesubscription 00000000-0000-0000-0000-000000000000, rollback = False: 
 Microsoft.SharePoint.Administration.DatabaseProvider.DatabaseProviderException: 
 CREATE DATABASE permission denied in database 'master'.  

Answer 6

Just to add a bit more to @Kai's answer:

New-SPServiceApplicationPool -Name "AccessServiceAppPool" -Account contoso\sp_accessservice

$serviceapp = Get-SPServiceApplication *GUID-of-your-service-app*

$serviceAppPool = Get-SPServiceApplicationPool | ? { $_.Name -eq "AccessServiceAppPool" }

$serviceapp.ApplicationPool = $serviceAppPool
$serviceapp.Update()