SharePoint 2010 creating Access Services 2013 error

Apr 23, 2013 at 1:39 PM
When deploying SP13 (enterprise) with AutoSPInstaller and I select all Enterprise Services (excel, access) I get the following error time after time.
This happens with spsetup account being sql sysadmin, filled in the FQDN of the sql server instead of using the sql alias.

New-SPAccessServicesApplication : A connection could be established to the Application Database Server but mixed mode a
uthentication isn't enabled.
At line:1 char:1
  • New-SPAccessServicesApplication -DatabaseServer sharepoint -Default -Name "Acces ...
    • ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : ObjectNotFound: (Access Services:String) [New-SPAccessServicesApplication], InvalidOpera
      tionException
      • FullyQualifiedErrorId : Microsoft.Office.Access.Services.PowerShell.NewSPAccessServicesApplication
WARNING: An error occurred provisioning Access Services! Check the log for any details, then try again.
Apr 23, 2013 at 3:24 PM
http://www.google.nl/url?sa=t&rct=j&q=sharepoint%202013%20sql%20mixed%20mode%20authentication&source=web&cd=1&cad=rja&ved=0CDAQFjAA&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F8%2F0%2F4%2F8041D29A-8FD1-486E-BD2E-68558BA8AF1F%2FAccessServices2013OnPremInstall.docx&ei=hZh2UZW_OsKwOYXggaAF&usg=AFQjCNFIgsd2W2GsJXtnpP9whR7ofxiz2Q&bvm=bv.45512109,d.ZWU

says:

Required SQL Server 2012 settings for Access apps
SQL Server 2012, which is the application database server for Access Services in SharePoint Server 2013, stores Access app objects, including data. It controls all query processing. To coordinate with Access Services, the SQL Server 2012 instance must include the following settings:
• SQL Instance Feature Selections:
o Database Engine Services
o Full-Text and Semantic Extractions for Search
o SQL Management Tools feature (for troubleshooting)
o Client Tools Connectivity
Note: You can set these features during installation or you can launch SQL Server Installation Center to install these features on an existing SQL Server instance. To launch the SQL Server Installation Center, from your Start menu select Microsoft SQL Server 2012. Select Configuration Tools. Select SQL Server Installation Center.
• Security Mode = Mixed Mode (SQL Server authentication and Windows authentication)
• An SA password
• The Service Account that runs Access Services must have the following Server Roles on the SQL Server Security Logins table:
o dbcreator
o securityadmin
• Enable Contained Databases = True
• Allow Triggers to Fire Others = True
• Default Language = English
• TCP/IP Protocol = Enabled
• Named Pipes Protocol= Enabled
• Windows Firewall Inbound Ports TCP 1433, TCP 1434, and UDP 1434


Note: You assign the Service Account when you configure the SharePoint farm.
• Enable Contained Databases = True
• Allow Triggers to Fire Others = True
• Default Language = English
• TCP/IP Protocol = Enabled
• Named Pipes Protocol= Enabled
• Windows Firewall Inbound Ports TCP 1433, TCP 1434, and UDP 1434