none
SQL server on nano server RRS feed

  • Question

  • I'm going to setup a web server using nano server so I need to install both iis and SQL server on it. I'm ok with iis but how can I have SQL server on nano server?? is it possible to install SQL server on nano server same as windows server core and manage it remotely? thanx MVPs
    Saturday, May 14, 2016 5:27 PM

Answers

  • Hi Cyrus I would suggest this is not possible. Checkout this link https://technet.microsoft.com/en-us/library/mt627783.aspx You currently cannot install all elements of the web server to nano in TP5, I would suggest having the SQL server on a core machine and point the web server at that. This would allow multiple nanos running web front ends to the same SQL server. Cheers Yours Ed Please mark this as an answer if it was helpful to you
    • Marked as answer by cyrusgreat Sunday, May 15, 2016 4:00 AM
    Saturday, May 14, 2016 6:14 PM

All replies

  • Hi Cyrus I would suggest this is not possible. Checkout this link https://technet.microsoft.com/en-us/library/mt627783.aspx You currently cannot install all elements of the web server to nano in TP5, I would suggest having the SQL server on a core machine and point the web server at that. This would allow multiple nanos running web front ends to the same SQL server. Cheers Yours Ed Please mark this as an answer if it was helpful to you
    • Marked as answer by cyrusgreat Sunday, May 15, 2016 4:00 AM
    Saturday, May 14, 2016 6:14 PM
  • Hi Cyrus I would suggest this is not possible. Checkout this link https://technet.microsoft.com/en-us/library/mt627783.aspx You currently cannot install all elements of the web server to nano in TP5, I would suggest having the SQL server on a core machine and point the web server at that. This would allow multiple nanos running web front ends to the same SQL server. Cheers Yours Ed Please mark this as an answer if it was helpful to you

    thanx Ed, it was helpful.
    Sunday, May 15, 2016 4:02 AM
  • It may be possible to install SQL express 2014 in a docker container on nano: https://26thcentury.com/2016/01/03/dockerfile-to-create-sql-server-express-windows-container-image/


    • Edited by Jamie Bilinski Tuesday, May 24, 2016 5:45 PM version correction
    Tuesday, May 24, 2016 5:41 PM