none
Access Services

    Question

  • Hello,

    I have SharePoint 2013 running with SQL 2012 SP1, tried configuring Access Services following the steps given here  but when i try creating a Customer Web App using Access 2013 but i still get the error below. Please advise, you can also assist with another link that has a working solution for the same.


    Meshack


    • Edited by Meshack KE Tuesday, January 14, 2014 7:24 AM
    Tuesday, January 14, 2014 7:23 AM

All replies

  • No servers available for database creation

    Alert Name: Access Services: No servers available for database creation

    Summary: During application creation, Access Data services cannot find an available SQL Server to provision the new database.

    Cause

    No SQL database servers are configured for Access to provision new databases.

    Resolution

    • If the creation failure occurs while creating from the Access client, check the Database Server group mappings to determine where the shortage has occurred:

      1. Use Get-SPAccessServicesDatabaseServerGroupMapping to determine whether there is a mapping from the Object Model to the Server Group.

      2. Use Get-SPAccessServicesDatabaseServerGroup to determine whether the server group has at least one database.

      3. Use Get-SPAccessServicesDatabaseServer to determine whether there is at least one database in the server group marked as "AvailableForCreate".

    • If the creation failure occurs while creating from the Corporate Catalog, check the Database Server group mappings to determine where the shortage has occurred:

      1. Use Get-SPAccessServicesDatabaseServerGroupMapping to determine whether there is a mapping from the Corporate Catalog to the Server Group.

      2. Use Get-SPAccessServicesDatabaseServerGroup to determine whether the server group has at least one database.

      3. Use Get-SPAccessServicesDatabaseServer to determine whether there is at least one database in the server group marked as "AvailableForCreate".

    good technet for the troubleshooting and known issues.

    http://technet.microsoft.com/en-us/library/ee513071.aspx#NoServers


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

    Tuesday, January 14, 2014 7:41 AM
  • I had seen this but when i run its asking for ServiceContext: what do i key in here?


    Meshack

    Tuesday, January 14, 2014 8:59 AM
  • on which command you are geting /its asking? screen shot of poweshell if possible?

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

    Tuesday, January 14, 2014 2:02 PM
  • Hi ,

    Here is how you get the Service context object.

    $site = new-object Microsoft.SharePoint.SPSite(<any site on your farm which has this service application associated>);  
    $ServiceContext = [Microsoft.SharePoint.SPServiceContext]::GetContext($site);  

    HTH.


    -Sangeetha

    Tuesday, January 14, 2014 2:13 PM
  • This is what am gettin, what do i key in on  ServiceContext:?

    PS C:\Users\SPInstall> Get-SPAccessServicesDatabaseServerGroupMapping

    cmdlet Get-SPAccessServicesDatabaseServerGroupMapping at command pipeline
    position 1
    Supply values for the following parameters:
    ServiceContext:

    On the other command i get

    PS C:\Users\SPInstall> $site = new-object Microsoft.SharePoint.SPSite(https://SPSERVER)
    https://SPSERVER : The term 'https://SPSERVER' is not recognized as the name of
    a cmdlet, function, script file, or operable program. Check the spelling of
    the name, or if a path was included, verify that the path is correct and try
    again.
    At line:1 char:48
    + $site = new-object Microsoft.SharePoint.SPSite(https://SPSERVER)
    +                                                ~~~~~~~~~~~~~~~
        + CategoryInfo          : ObjectNotFound: (https://SPSERVER:String) [], Com
       mandNotFoundException
        + FullyQualifiedErrorId : CommandNotFoundException

    PS C:\Users\SPInstall> $ServiceContext = [Microsoft.SharePoint.SPServiceContext]
    ::GetContext($site)
    Multiple ambiguous overloads found for "GetContext" and the argument count:
    "1".
    At line:1 char:1
    + $ServiceContext = [Microsoft.SharePoint.SPServiceContext]::GetContext($site)
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        + CategoryInfo          : NotSpecified: (:) [], MethodException
        + FullyQualifiedErrorId : MethodCountCouldNotFindBest


    Meshack

    Wednesday, January 15, 2014 6:28 AM
  • Hi Meshack,

    Please add a double quotes for the site url as below, then run PowerShell again.

    $site = new-object Microsoft.SharePoint.SPSite("https://SPSERVER")
    $ServiceContext = [Microsoft.SharePoint.SPServiceContext]::GetContext($site) 
    
    Thanks

    Daniel Yang
    TechNet Community Support

    Wednesday, January 15, 2014 12:39 PM
    Moderator
  • Hello,

    This command doesnt return any results it just goes blank, i have tried saving the whole command as Name.ps1 and run using SharePoint PowerShell but still goes blank even when i paste them direct on powershell, am i missing something?


    Meshack

    Monday, January 27, 2014 1:24 PM
  • try this way:

    $site = new-object Microsoft.SharePoint.SPSite("https://SPSERVER")
    $Site

    see if you get any thing to display if nothing then URL of the site is not correct.

    but if you get correct url then go this line.

    $ServiceContext = [Microsoft.SharePoint.SPServiceContext]::GetContext($site) 


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

    Wednesday, January 29, 2014 6:33 PM
  • Am getting the site but the context doesn't return results

    PS C:\Users\SPInstall> $site = new-object Microsoft.SharePoint.SPSite("https://SPSERVER")
    PS C:\Users\SPInstall> $Site
    
    Url                                                     CompatibilityLevel
    ---                                                     ------------------
    https://SPSERVER                                      15
    
    
    PS C:\Users\SPInstall> $ServiceContext = [Microsoft.SharePoint.SPServiceContext]::GetContext($site)
    PS C:\Users\SPInstall>



    Meshack


    • Edited by Meshack KE Thursday, January 30, 2014 4:58 AM
    Thursday, January 30, 2014 4:51 AM
  • now run this:

    $dsgm = Get-SPAccessServicesDatabaseServerGroupMapping -ServiceContext $context

    and then

    $dsgm


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

    Thursday, January 30, 2014 4:59 AM
  • Seems like there's something missing on the code?
    PS C:\Users\SPInstall> $dsgm = Get-SPAccessServicesDatabaseServerGroupMapping -ServiceContext $context
    Get-SPAccessServicesDatabaseServerGroupMapping : Cannot bind argument to parameter 'ServiceContext' because it is null.
    At line:1 char:72
    + $dsgm = Get-SPAccessServicesDatabaseServerGroupMapping -ServiceContext $context
    +                                                                        ~~~~~~~~
        + CategoryInfo          : InvalidData: (:) [Get-SPAccessSer...verGroupMapping], ParameterBindingValidationException
        + FullyQualifiedErrorId : ParameterArgumentValidationErrorNullNotAllowed,Microsoft.Office.Access.Services.PowerShell.Ge
       tSPAccessServicesDatabaseServerGroupMapping
    


    Meshack

    Thursday, January 30, 2014 5:02 AM
  • ok lets do other way....these are all get commands will not hurt just for information.

    run each line in the same order

    $ASapp = Get-SPAccessServicesApplication
    
    $app = $Null
    
    if ($ASapp.length -ne $Null) { $app = $ASapp[0] } else { $app = $ASapp }
    
    $context = [Microsoft.SharePoint.SPServiceContext]::GetContext($app.ServiceApplicationProxyGroup, [Microsoft.SharePoint.SPSiteSubscriptionIdentifier]::Default)
    
    $dsgm = Get-SPAccessServicesDatabaseServerGroupMapping -ServiceContext $context


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

    Thursday, January 30, 2014 5:05 AM
  • Thanks Waqas for the support, This one returned something, what do try next?
    PS C:\Users\SPInstall> $ASapp = Get-SPAccessServicesApplication
    PS C:\Users\SPInstall> $app = $Null
    PS C:\Users\SPInstall> if ($ASapp.length -ne $Null) { $app = $ASapp[0] } else { $app = $ASapp }
    PS C:\Users\SPInstall> $context = [Microsoft.SharePoint.SPServiceContext]::GetContext($app.ServiceApplicationProxyGroup, [Microsoft.SharePoint.SPSiteSubscriptionIdentifier]::Default)
    PS C:\Users\SPInstall> $dsgm = Get-SPAccessServicesDatabaseServerGroupMapping -ServiceContext $context
    PS C:\Users\SPInstall> $dsgm
    
                                                     PackageSource Group
                                                     ------------- -----
                                                       Marketplace DEFAULT
                                                  CorporateCatalog DEFAULT
                                                     DeveloperSite DEFAULT
                                                       ObjectModel DEFAULT
                                                 RemoteObjectModel DEFAULT
    


    Meshack

    Thursday, January 30, 2014 5:09 AM
  • now run these two and sahre the result.

    $dsgm1 = Get-SPAccessServicesDatabaseServerGroupMapping -ServiceContext $context

    and

    $getservers = Get-SPAccessServicesDatabaseServer $context


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

    Thursday, January 30, 2014 5:13 AM
  • Is it supposed to return something? am not getting any results

    Meshack

    Thursday, January 30, 2014 5:18 AM
  • yes, from 

    $dsgm1

    & $getservers


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

    Thursday, January 30, 2014 5:20 AM
  • This is what's showing

    PS C:\Users\SPInstall> $dsgm1 = Get-SPAccessServicesDatabaseServerGroupMapping -ServiceContext $context
    PS C:\Users\SPInstall> $getservers = Get-SPAccessServicesDatabaseServer $context
    PS C:\Users\SPInstall> $dsgm1
    
                                                     PackageSource Group
                                                     ------------- -----
                                                       Marketplace DEFAULT
                                                  CorporateCatalog DEFAULT
                                                     DeveloperSite DEFAULT
                                                       ObjectModel DEFAULT
                                                 RemoteObjectModel DEFAULT
    
    
    PS C:\Users\SPInstall> $getservers
    PS C:\Users\SPInstall>


    Meshack

    Thursday, January 30, 2014 5:22 AM
  • also check this white paper.

    http://www.microsoft.com/en-us/download/details.aspx?id=30445

    and this is revised blog post for configuration...

    i would try to delete the current access serivces and try to create new one.

    http://blogs.msdn.com/b/kaevans/archive/2013/07/14/access-services-2013-setup-for-an-on-premises-installation.aspx


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

    Thursday, January 30, 2014 5:22 AM
  • try this so that we can get the server 

    $ASapp = Get-SPAccessServicesApplication
    
    $app = $Null
    
    if ($ASapp.length -ne $Null) { $app = $ASapp[0] } else { $app = $ASapp }
    
    $context = [Microsoft.SharePoint.SPServiceContext]::GetContext($app.ServiceApplicationProxyGroup, [Microsoft.SharePoint.SPSiteSubscriptionIdentifier]::Default)
    
    $server2 = $Null
    
    $getservers = Get-SPAccessServicesDatabaseServer $context


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

    Thursday, January 30, 2014 5:24 AM
  • Thanks Men, let me go through will update you

    Meshack

    Thursday, January 30, 2014 5:48 AM