Error Provisioning Access Services

Jun 23, 2013 at 11:11 PM
Edited Jun 24, 2013 at 12:31 PM
So getting an error on install related to Access Services. Which log should I be checking do you think? I do have SQL installed in mixed mode by the way.
  • Provisioning Access Service...
  • Checking Access Services instance...
  • Access Services instance already started.
  • Creating Access Service...
    New-SPAccessServicesApplication : A connection could be established to the Application Database Server but mixed mode
    authentication isn't enabled.
    At line:1 char:1
  • New-SPAccessServicesApplication -DatabaseServer TSDEMO01 -Default -Name "Access ...
  • ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : ObjectNotFound: (Access Service:String) [New-SPAccessServicesApplication], InvalidOperat
    • FullyQualifiedErrorId : Microsoft.Office.Access.Services.PowerShell.NewSPAccessServicesApplication
WARNING: An error occurred provisioning Access Service! Check the log for any details, then try again.
Jun 24, 2013 at 1:40 PM
BTW. This was SQL 2012 and SP 2013 and was doing Access Services 2013. Just in case that helps.
Jun 24, 2013 at 7:11 PM
Do you have mixed mode authentication turned on? It is required.
Jun 25, 2013 at 12:30 AM
That was it. I had an error in my PowerShell script to install SQL in this box and it didn't setup Mixed Mode. Thanks.