Access Services apologizes – “Sorry, something went wrong”

I was recently working with Access Services in SharePoint 2013 in my dev environment, and every time I created a new App for access I was immediately confronted with the following error “Sorry, something went wrong. An unexpected error has occurred.

clip_image001

Unexpected indeed! Thanks for that very informative error message, your politeness however is of little practical use to me. After spending more time than I care to admit publicly, we were able to eventually track this problem down to the fact that the account running the Access Services service application didn’t have the appropriate permissions to the SharePoint content database. I was using a domain account of CONTOSO\sp_accsvc to run the service application. To fix the problem, we ultimately needed to grant the CONTOSO\sp_accsvc account access to the “SPDataAccess” role in the SharePoint configuration database (in SQL Server). After doing that (and running an iisreset on the SharePoint box) POOF! I’m creating Access Apps error free!

clip_image003

Hopefully this will save someone some time (like myself in the future once I forget).

3 thoughts on “Access Services apologizes – “Sorry, something went wrong”

  1. You’re a King! :-)
    Thanks a lot!
    I thought it might be something with access (not Access), but this save a lot of time!

Leave a Reply

Your email address will not be published. Required fields are marked *


one × = 5

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>