How to restore Access Apps after Service Applications crashed.

Hey guys,

I have an issue were I was forced to rebuild the service applications for my SharePoint 2013 environment. As a result, I've spend quite some time attempting to restore our Web Applications. I have completed the majority of the restore and SharePoint is working well, except for a few custom Access Web Apps that were built previously. If I add a new Access App it is successful, however trying to access the old apps results in the error "Sorry, we couldn't load this app. We weren't able to load the app's home page." The ULS log is leading me to believe it is because the app is still looking for the all Access Service and Application pool because it errors with "Cannot find site lookup info for request Uri http://<server>:<Port>/<New app pool guid>/AccessService.svc."  I normally would restore the app from an app package and then the data however this particular app was developed on a server running SQL 2014 and the user couldn't produce an app package for some reason. (something else to look into after this). Long story short, I'm trying to see if there is a way to update the service call for the app to the new service applications, or if there is a way to restore the app from the database considering that database holds everything for the app.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CooperRiisAuthor Commented:
Ok, after more research, I've realized that the log continues with "AccessServicesDatabaseServerGroupCollection.GetDatabaseServer: Could not find a server matching reference id 'd94ad509-e5ac-4243-ba8f-9ac78a196f1e'. Returning null."

Previously I believed this was due to the fact that it was not able to find the service, however, when I use my Get-SPAccessServicesDatabaServer PS cmd, I am given the ServerReferenceID "dea59c3c-2ddd-48d6-ac01-a4ba6a7c7511"

The app is looking for the wrong database it seems but I can't be sure. As a test I created a new test app and then restored the old app's SQL database over the test apps SQL database. This resulted in the same error messages, so I'm thinking the value is stored somewhere in the SQL database.

Any ideas would be very helpful...
CooperRiisAuthor Commented:
I found what I was looking for and was able to get the services and all of my apps working again.

In case anyone else is having this problem, look in the AppDataMetadata and AppInstallationProperty tables of your Web Application content database on which the erring apps are installed. In the AppDatabaseMetadata table the referenceId should point to the Guid of your database server that can be found using the Get-SPAccessServiceDatabaseServer PS cmd. Mine was pointing to the old server Guid which was appearing in the error code "AccessServicesDatabaseServerGroupCollection.GetDatabaseServer: Could not find a server matching reference id 'd94ad509-e5ac-4243-ba8f-9ac78a196f1e'. Returning null."  Next update the value field in the AppInstallationProperty table where the ValueKey = ServerReferenceID. Once I changed there fields for the erring apps to the updated database server Guid the apps began working again.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.