Problem
After configuring Access Services you cannot deploy Access custom web apps from Access 2013 – an error with a Correlation ID occurs.
Reason
As if it´s not inconvenient enough to configure the SharePoint Access Services Requirements (e.g. AppStore with DNS), the SQL Server Configuration can be the cause, too. In the SharePoint Site Content overview you can see the faulty deployed App and in it`s details the following error:
The database server is temporarily unavailable.
Details: The sp_configure value ‘contained database authentication’ must be set to 1 in order to alter a contained database. You may need to use RECONFIGURE to set the value_in_use. ALTER DATABASE statement failed.
Solution
You need to enable the SQL Server 2012 Feature Contained Database Authentication if you receive this error. You can do this in the Management Studio via this T-SQL statement:
SP_CONFIGURE 'contained database authentication', 1;GORECONFIGURE;GO
Enjoy SharePoint!
