locked
Subscription Setting Service and Subscription Setting Proxy Servie RRS feed

  • Question

  • Hello All,  I am trying to activate apps on my Sharepoint 13 install.  I keep running into issue trying to set up the Subscription Setting and Proxy services.  From what I have read it can only be done in Powershell.  I have found several commands on the internet but can not get them to work. 

    These are the steps i am using but all i get is errors in powershell

    2)  Open the SharePoint 2013 Management Shell as Administrator.

    3)  Verify the Name of the Application Pool.
    PS C:\ Get-SPServiceApplicationPool | Select Name

    4)  Set the Service Application Pool in a variable.
    $SvcAppPool03 = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_03"

    5)  Create the Service Application and assign it to the Application Pool.
    $SvcApp = New-SPSubscriptionSettingsServiceApplication -ApplicationPool $SvcAppPool03 -Name "SvcApp_SPSubscriptionSettingsServiceApplication_01" -DatabaseName "SvcApp_SPSubscriptionSettingsServiceApplication_01_DB_01" -DatabaseServer "MSSQL Client Alias"
     
    6)  Verify the Service Application.
    PS C:\ Get-SPServiceApplication | Select Name

    5)  Create the Service Application Proxy and assign it to the Service Application.
    $SvcAppProxy = New-SPSubscriptionSettingsServiceApplicationProxy -ServiceApplication $SvcApp

    It does not appear that the name of the Proxy can be set using the cmdlet.  SharePoint will name the Proxy automatically. 

    7)  Verify Service Application Proxy.
    PS C:\ Get-SPServiceApplicationProxy | Select Name

    8)  Start the Service Instance.
    Get-SPServiceInstance | where{$_.TypeName -eq "Microsoft SharePoint Foundation Subscription Settings Service"} | Start-SPServiceInstance

    I can run 3-5 but get stuck in the middle of 5 at the ApplicationPool:

    Friday, March 25, 2016 4:11 PM

Answers

  • Can you post the screenshot of the Manage Service application page. Or output of the following commands.

    Get-SPServiceApplication | ? TypeName -like "*Subscription*" | Select TypeName, Id
    Get-SPServiceApplicationProxy | ? TypeName -like "*Subscription*"

    Additionally Here is what you can do.

    Go to Manage service application page and delete any existing subscription setting service application with data.

    login to Sql management studio and make sure the database is deleted from sql.

    now run the following script one line at  time.

    iisreset on app server.

    $Service = "Microsoft SharePoint Foundation Subscription Settings Service"
    $SubSettingService = Get-SPServiceInstance | ? TypeName -eq $Service
    $SubSettingService | Stop-SPServiceInstance -Confirm:$false -Verbose
    #Run below and wait for service to become disabled
    Get-SPServiceInstance | ? TypeName -eq $Service
    $SubSettingService | Start-SPServiceInstance -Verbose
    #Run below and wait for service to become Online
    Get-SPServiceInstance | ? TypeName -eq $Service
    
    $Subscription = New-SPSubscriptionSettingsServiceApplication -ApplicationPool "SharePoint Web Services Default" -Name "Subscription Settings Service Application" -DatabaseName "SubscriptionSettingsDB"
    New-SPSubscriptionSettingsServiceApplicationProxy -ServiceApplication $Subscription -Verbose


    Jerry Yasir - Office Server & Services MVP/MCT Hewlett Packard Enterprise - If this reply helped you resolve your issue, please propose as answer. It may help other community members. Thanks!

    Friday, March 25, 2016 8:33 PM
  • Hi,

    Or you trying to provision the stand alone Subscription Setting service application without associating the App Management Service application ?

    Possible reason could be:

    It seems that you might trying to create the service application/application pool / or Database name that already exist on your server.

    Why don't you try the exact script which posted on MSDN

    $account = Get-SPManagedAccount "domain\user" 
    $appPoolSubSvc = New-SPServiceApplicationPool -Name SettingsServiceAppPool -Account $account
    $appPoolAppSvc = New-SPServiceApplicationPool -Name AppServiceAppPool -Account $account
    $appSubSvc = New-SPSubscriptionSettingsServiceApplication -ApplicationPool $appPoolSubSvc -Name SettingsServiceApp -DatabaseName SettingsServiceDB 
    $proxySubSvc = New-SPSubscriptionSettingsServiceApplicationProxy -ServiceApplication $appSubSvc
    $appAppSvc = New-SPAppManagementServiceApplication -ApplicationPool $appPoolAppSvc -Name AppServiceApp -DatabaseName AppServiceDB
    $proxyAppSvc = New-SPAppManagementServiceApplicationProxy -ServiceApplication $appAppSvc


    Murugesa Pandian | MCPD | MCTS | SharePoint 2010 |


    Saturday, March 26, 2016 4:09 AM

All replies

  • You script look fine. It would be lot better if you put a screenshot of the error here.  If you are getting error on app pool then run the following line only. 

    Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_03"

    This should return the application pool.  If not then check the application pool exit. You may need to create this application pool using New-SPServiceApplicationPool which also need a managed account. 

    You can also try a basic easy method.

    New-SPSubscriptionSettingsServiceApplication -ApplicationPool "SharePoint Web Services Default" -Name "Subscription Settings Service Application" -DatabaseName "SubscriptionSettingsDB" | New-SPSubscriptionSettingsServiceApplicationProxy
    Get-SPServiceInstance | ? TypeName -eq "Microsoft SharePoint Foundation Subscription Settings Service" | Start-SPServiceInstance






    Jerry Yasir - Office Server & Services MVP/MCT Hewlett Packard Enterprise - If this reply helped you resolve your issue, please propose as answer. It may help other community members. Thanks!

    Friday, March 25, 2016 4:42 PM
  • I have got all the way to the Proxy command but I am not sure what to put as the address for the proxy.  I am getting this error.

    New-SPSubscriptionSettingsServiceApplicationProxy : The specified service URI
    cannot be load balanced by the default Load Balancer

    Friday, March 25, 2016 5:37 PM
  • Can you post the screenshot of the Manage Service application page. Or output of the following commands.

    Get-SPServiceApplication | ? TypeName -like "*Subscription*" | Select TypeName, Id
    Get-SPServiceApplicationProxy | ? TypeName -like "*Subscription*"

    Additionally Here is what you can do.

    Go to Manage service application page and delete any existing subscription setting service application with data.

    login to Sql management studio and make sure the database is deleted from sql.

    now run the following script one line at  time.

    iisreset on app server.

    $Service = "Microsoft SharePoint Foundation Subscription Settings Service"
    $SubSettingService = Get-SPServiceInstance | ? TypeName -eq $Service
    $SubSettingService | Stop-SPServiceInstance -Confirm:$false -Verbose
    #Run below and wait for service to become disabled
    Get-SPServiceInstance | ? TypeName -eq $Service
    $SubSettingService | Start-SPServiceInstance -Verbose
    #Run below and wait for service to become Online
    Get-SPServiceInstance | ? TypeName -eq $Service
    
    $Subscription = New-SPSubscriptionSettingsServiceApplication -ApplicationPool "SharePoint Web Services Default" -Name "Subscription Settings Service Application" -DatabaseName "SubscriptionSettingsDB"
    New-SPSubscriptionSettingsServiceApplicationProxy -ServiceApplication $Subscription -Verbose


    Jerry Yasir - Office Server & Services MVP/MCT Hewlett Packard Enterprise - If this reply helped you resolve your issue, please propose as answer. It may help other community members. Thanks!

    Friday, March 25, 2016 8:33 PM
  • Hi,

    Or you trying to provision the stand alone Subscription Setting service application without associating the App Management Service application ?

    Possible reason could be:

    It seems that you might trying to create the service application/application pool / or Database name that already exist on your server.

    Why don't you try the exact script which posted on MSDN

    $account = Get-SPManagedAccount "domain\user" 
    $appPoolSubSvc = New-SPServiceApplicationPool -Name SettingsServiceAppPool -Account $account
    $appPoolAppSvc = New-SPServiceApplicationPool -Name AppServiceAppPool -Account $account
    $appSubSvc = New-SPSubscriptionSettingsServiceApplication -ApplicationPool $appPoolSubSvc -Name SettingsServiceApp -DatabaseName SettingsServiceDB 
    $proxySubSvc = New-SPSubscriptionSettingsServiceApplicationProxy -ServiceApplication $appSubSvc
    $appAppSvc = New-SPAppManagementServiceApplication -ApplicationPool $appPoolAppSvc -Name AppServiceApp -DatabaseName AppServiceDB
    $proxyAppSvc = New-SPAppManagementServiceApplicationProxy -ServiceApplication $appAppSvc


    Murugesa Pandian | MCPD | MCTS | SharePoint 2010 |


    Saturday, March 26, 2016 4:09 AM