Fun, new stuff today. I installed an instance of Ubuntu on my Oracle VirtualBox hypervisor and then installed SQL Server 2017 using the directions found here. Once installation was complete I used systemctl status mssql-server to validate that the services were running and then connected to the database engine using SSMS on my windows desktop. Two VirtualBox settings of note:
- The network adapter was set to the Bridged Adapter – the actual physical adapter in my lab PC.
- The minimum memory required to install SQL Server is 3.5GB.
For my home lab, I really like being able to install SQL Server 2017 on a Linux machine. It eliminates having to consume a Windows Server license activation.
Update 6/25/2017: Today I provisioned an instance of Ubuntu server on Azure and went on to install SQL Server 2017 on that instance. One key difference with Azure is that you need to add an inbound security rule to the network interface on port 1433 in order to remotely manage the SQL Server instance.