locked
Access Services Setup Sharepoint 2016, and SQL 2016: An application could not be provisioned because there are no available database servers. RRS feed

  • Question

  • I installed Sharepoint 2016, after being promised the world from the sales team. I can't find for the life of me any steps to setup access services so I can create webapps. I try to create an access database either through Sharepoint 2016 or through Access 2016 I get the following error:

    An application could not be provisioned because there are no available database servers.


    Wednesday, December 7, 2016 4:07 PM

Answers

  • Can you uncheck "<label for="ctl00_PlaceHolderDialogBodySection_PlaceHolderDialogBodyMainSection_m_applicationDatabaseSection_AccessDatabaseFormSection_ChkValidateServer">Validate the application database server (recommended)" when creating your Access Services service app? I believe this issue was fixed a few months after RTM in a PU.</label>

    Trevor Seward

    Office Servers and Services MVP



    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    • Marked as answer by w1llbuck Thursday, December 8, 2016 7:00 PM
    Wednesday, December 7, 2016 10:16 PM

All replies

  • Is your database up and running? Is it running on the SharePoint server or are you apart of a farm?

    Not having access services configured shouldn't prevent you from creating a Web Application.


    Thanks, Danny Hickman IT Support Specialist

    Wednesday, December 7, 2016 8:40 PM
  • https://technet.microsoft.com/en-us/library/ee748653.aspx

    Thanks, Danny Hickman IT Support Specialist

    Wednesday, December 7, 2016 8:41 PM
  • Thank you for the response Danny, It is running on the same server. Access Services show as started, Access Services 2010 show as started. 
    Wednesday, December 7, 2016 9:31 PM
  • What is your SQL server version, most probably that version may not compatible with Access Service or may be permission on the Sql Server. Make sure the service account running the Access service should have proper permission on the DB server


    Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -WS MCITP(SharePoint 2010, 2013) Blog: http://krossfarm.com


    Wednesday, December 7, 2016 9:58 PM
  • I verified that everything in that article is done properly, and running. I still get the same error when trying to create an access web app.
    Wednesday, December 7, 2016 10:02 PM
  • Can you uncheck "<label for="ctl00_PlaceHolderDialogBodySection_PlaceHolderDialogBodyMainSection_m_applicationDatabaseSection_AccessDatabaseFormSection_ChkValidateServer">Validate the application database server (recommended)" when creating your Access Services service app? I believe this issue was fixed a few months after RTM in a PU.</label>

    Trevor Seward

    Office Servers and Services MVP



    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    • Marked as answer by w1llbuck Thursday, December 8, 2016 7:00 PM
    Wednesday, December 7, 2016 10:16 PM
  • 2016 Enterprise, and Sharepoint 2016 Enterprise.
    Wednesday, December 7, 2016 11:54 PM
  • I am one step closed, thank you Trevor. Now it adds the app to my inventory, but it says Sorry, something went wrong with adding the app beside it in red.
    Thursday, December 8, 2016 12:15 AM
  • This is the error I'm seeing on the Server now: 
    There was a problem accessing the app's database.

    Details: Unable to obtain master key

    so at least it is a new error

    Thursday, December 8, 2016 12:29 AM
  • I'm going to mark the answer from Trevor as the correct answer as it changed the error code. I also had to set enabled contained databases to True, and create a key in the secure store service. Now I can create access webapps. Though I will say Microsoft should have this better documented, as I had to find the information in articles for Sharepoint 2013.
    Thursday, December 8, 2016 7:00 PM
  • So can you repeat the step you use to make it work... here my situation 1.service running, when trying to provision, the page crash.... . Nothing can go further ///?
    Thursday, March 16, 2017 10:12 AM