locked
IOT Edge SQL Server module for Windows? RRS feed

  • Question

  • According to the page for the SQL Server module for IOT Edge on the IOT Edge module market place it is only available for Linux containers. A main requirement for the IOTEdge solution we implemented for a customer was that it should be based on Windows containers. 

    (module page: https://azuremarketplace.microsoft.com/en/marketplace/apps/microsoft.edge-sql-server-2017)

    I quote:

    "Minimum hardware requirements: Linux containers (see this tutorial for a windows containers version), x64, 2Gb of disk space, 2Gb of RAM"

    I you go to the link that is provided for windows containers, you get a page that specifically mentions that the tutorial is for a Linux based solution as well.

    (supposed tutorial page for "windows containers version": https://docs.microsoft.com/nl-nl/azure/iot-edge/tutorial-store-data-sql-server)

    Can the module in question be deployed to a Windows Container after all? Or how do we get a SQL Server module on a Windows based IOTEdge container.

    Thursday, September 19, 2019 1:31 PM

Answers

  • Hi Johan,

    I confirmed that the Module doesn't support Windows containers, the team is working on updating the Marketplace page.

    The SQL module uses SQL Server 2017. The choice of edition is dependent on the customer. Please note this is a BYOL module, which means customers have to bring their own license, which can be either Enterprise or Standard.

     
    Once deployed, you should be able to use any SQL tool (including SSMS, ADS or command line) tools to manage SQL.

    Thursday, October 3, 2019 8:18 PM

All replies

  • Hi Johan Berghmans (CGI) thanks to bringing this to our attention! I will investigate and get back to you soon.
    Friday, September 20, 2019 4:41 PM
  • Hi Alberto,

    Do you have any information for me yet?

    Also - I would like to know what edition of SQL Server is used for the SQL module. I can't find any information about this in the documentation.

    Plus - can you only manage the SQL server module by using the command line SQL command tool?

    With kind regards,

    Johan Berghmans.

    Wednesday, September 25, 2019 8:50 AM
  • Hi sorry for the delay. I am still waiting to hear back and I added your other questions too.
    Friday, September 27, 2019 8:10 PM
  • Hi Johan,

    I confirmed that the Module doesn't support Windows containers, the team is working on updating the Marketplace page.

    The SQL module uses SQL Server 2017. The choice of edition is dependent on the customer. Please note this is a BYOL module, which means customers have to bring their own license, which can be either Enterprise or Standard.

     
    Once deployed, you should be able to use any SQL tool (including SSMS, ADS or command line) tools to manage SQL.

    Thursday, October 3, 2019 8:18 PM
  • Hi Alberto,

    But will there be a release of a Windows container version? Otherwise we will have to use a separate Docker container, but we'd prefer having an Edge version.

    Furthermore - how do you pick the edition then? Because normally you pick the edition when installing SQL Server. You could for instance pick the Express edition, in stead of Enterprise or Standard. In a lot of "Edge" scenario's I believe a Express edition would fit better. You don't always need the overhead of an Enterprise or Standard edition.

    With kind regards,

    Johan Berghmans.

    Friday, October 4, 2019 6:13 AM
  • I'm afraid that at this point I do not have any information or ETA for Windows support. You can select the edition doing something like this:

    docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=yourStrong(!)Password' -e 'MSSQL_PID=Express' -p 1433:1433 -d mcr.microsoft.com/mssql/server:2017-latest-ubuntu

    For more info please see: https://hub.docker.com/_/microsoft-mssql-server

    Friday, October 4, 2019 9:24 PM