none
Deploying SQL Server marketplace item in Azure Stack

    Question

  • Hi,

    I have syndicated an Azure marketplace item: Free License: SQL Server 2016 SP1 Developer Edition to my ASDK market place. When I want to deploy a VM out of it, I get an error:

    The selected image is not valid for the specified location. Select a different location

    See also attachment.

    What is going wrong overhere?

    Running ASDK version: 1.0.170928.3

    Regards,

    Theo


    Thursday, December 07, 2017 4:55 PM

All replies

  • Hello,

    Can you try installing the IaaS Extension for SQL  Server and then retry deploying your SQL Server?

     

    ### Add SQL IaaS extension

    New-Item "\\SU1FileServer\SU1_ObjStore\CRP\GuestArtifactRepository\SqlIaaSAgent" -ItemType Directory

    Invoke-WebRequest  https://labrg3248.blob.core.windows.net/vhds/SqlIaaSAgent_1_2_18_0.zip `

    -Outfile \\SU1FileServer\SU1_ObjStore\CRP\GuestArtifactRepository\SqlIaaSAgent\SqlIaaSAgent_1_2_18_0.zip

    Invoke-WebRequest  https://labrg3248.blob.core.windows.net/vhds/manifest.json `

    -Outfile \\SU1FileServer\SU1_ObjStore\CRP\GuestArtifactRepository\SqlIaaSAgent\manifest.json

           

     

    Let us know how it goes.

          

    We apologize for any inconvenience and appreciate your time and interest in Azure Stack.

    If you experience any issues with Azure Stack or the current ASDK release, please feel free to contact us.

           

     Thanks

     

     


    Thursday, December 07, 2017 8:43 PM
    Moderator
  • Hi Gary,

    I have tried your steps. The command:

    Invoke-WebRequest  https://labrg3248.blob.core.windows.net/vhds/SqlIaaSAgent_1_2_18_0.zip `
    -Outfile \\SU1FileServer\SU1_ObjStore\CRP\GuestArtifactRepository\SqlIaaSAgent\SqlIaaSAgent_1_2_18_0.zip

    returns that the blob cannot be found:

    Invoke-WebRequest : BlobNotFoundThe specified blob does not exist. RequestId:5975eb10-001e-0054-75fe-6fc763000000 
    Time:2017-12-08T08:29:57.4782029Z
    At line:1 char:1
    + Invoke-WebRequest  https://labrg3248.blob.core.windows.net/vhds/SqlIa ...
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        + CategoryInfo          : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-WebRequest], WebExceptio 
       n
        + FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeWebRequestCommand

    Regards,

    Theo

    Friday, December 08, 2017 8:43 AM