Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Background
When trying to configure access services in SharePoint 2013 this error appeared: "A connection could be established to the application database server but Mixed mode authentication isn’t enabled"
http://4.bp.blogspot.com/-_lq_SqEK0TA/UqFENym2IZI/AAAAAAAAA0k/lwlnT-CvNMw/s320/1.bmp
Cause:
For configuration of access services in SharePoint 2013 it has to be SQL Server 2012. It won’t work on SQL Server 2008 or R2.
We need to provide the Application database server as SQL Server 2012 only.
http://3.bp.blogspot.com/-yx08_U07rVA/UqFE1n7EqBI/AAAAAAAAA0s/MPHDoXPqfXE/s320/2.bmp
Note that you must have a SQL Server 2012 server to host these Access app databases. These databases don’t need to be on the same SQL Server as the rest of the SharePoint databases.
For a very detailed article on How to configure Access services 2013:
http://www.sp2013blog.com/Lists/Posts/Post.aspx?ID=37
See more at:
http://expertsharepoint.blogspot.de/2013/12/error-connection-could-be-established.htm
Note: If you find a different solution, please report it as a comment to this post. This will be useful to the SharePoint Community. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.