How to install SQL Server on an Azure VM.
Adapted from:
with this:
az.cmd vm create ^
--resource-group myResourceGroup ^
--name MSFT-DB-01 ^
--image MicrosoftSQLServer:SQL2017-RHEL7:SQLDEV:14.0.1000206 ^
--size Standard_DS1_V2 ^
--authentication-type password ^
--admin-username adm ^
--admin-password pwd ^
--location westeurope
sudo systemctl stop mssql-server
sudo /opt/mssql/bin/mssql-conf set-sa-password
sudo systemctl start mssql-server
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent
sudo firewall-cmd --reload
az.cmd network nsg rule create ^
--resource-group myGroup ^
--nsg-name MSFT-DB-01NSG ^
--name allow-sqlserver-hi ^
--protocol tcp ^
--priority 1010 ^
--destination-port-range 1433 ^
--source-address-prefixes yourStaticIP
That's it.
Test it:
sqlcmd -S localhost -U SA -P pwd
az.cmd vm start --name MSFT-DB-01 --resource-group myGroup
az.cmd vm show --name MSFT-DB-01 --resource-group myGroup -d --query [publicIps] --o tsv
az.cmd vm stop --name MSFT-DB-01 --resource-group myGroup