Ref: https:\/\/www.microsoft.com\/en-us\/sql-server\/developer-get-started\/php\/ubuntu<\/p>\n
1. Register the Microsoft Linux repositories and add their keys.
\nNote: it’d be better to use ‘sudo su’ first!<\/p>\n
teddy@teddy:~$ curl https:\/\/packages.microsoft.com\/keys\/microsoft.asc | sudo apt-key add -\r\n % Total % Received % Xferd Average Speed Time Time Time Current\r\n Dload Upload Total Spent Left Speed\r\n100 983 100 983 0 0 2323 0 --:--:-- --:--:-- --:--:-- 2329\r\nOK\r\n\r\nteddy@teddy:~$ curl https:\/\/packages.microsoft.com\/config\/ubuntu\/16.04\/mssql-server-2017.list | sudo tee \/etc\/apt\/sources.list.d\/mssql-server-2017.list\r\n % Total % Received % Xferd Average Speed Time Time Time Current\r\n Dload Upload Total Spent Left Speed\r\n100 91 100 91 0 0 102 0 --:--:-- --:--:-- --:--:-- 102\r\ndeb [arch=amd64] https:\/\/packages.microsoft.com\/ubuntu\/16.04\/mssql-server-2017 xenial main<\/pre>\n2. Install SQL Server.
\nNOTE: I USE ‘sudo apt-get install mssql-server=14.0.3192.2-2’ INSTEAD OF ‘sudo apt-get install mssql-server’ BECAUSE I GOT AN ERROR FOR SQLCMD ‘Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2746.’
\nREF: https:\/\/stackoverflow.com\/questions\/57265913\/error-tcp-provider-error-code-0x2746-during-the-sql-setup-in-linux-through-te<\/p>\nsudo apt-get update\r\n\r\nsudo apt-get install mssql-server=14.0.3192.2-2\r\n...\r\nSetting up mssql-server (14.0.3223.3-15) ...\r\n\r\n+--------------------------------------------------------------+\r\nPlease run 'sudo \/opt\/mssql\/bin\/mssql-conf setup'\r\nto complete the setup of Microsoft SQL Server\r\n+--------------------------------------------------------------+\r\n\r\nSQL Server needs to be restarted in order to apply this setting. Please run\r\n'systemctl restart mssql-server.service'.\r\nProcessing triggers for libc-bin (2.23-0ubuntu10) ...<\/pre>\n3. Setup your SQL Server.
\nNote: I choose ‘Developer’ edition.<\/p>\nteddy@teddy:~$ sudo \/opt\/mssql\/bin\/mssql-conf setup\r\nChoose an edition of SQL Server:\r\n 1) Evaluation (free, no production use rights, 180-day limit)\r\n 2) Developer (free, no production use rights)\r\n 3) Express (free)\r\n 4) Web (PAID)\r\n 5) Standard (PAID)\r\n 6) Enterprise (PAID)\r\n 7) Enterprise Core (PAID)\r\n 8) I bought a license through a retail sales channel and have a product key to enter.\r\n\r\nDetails about editions can be found at\r\nhttps:\/\/go.microsoft.com\/fwlink\/?LinkId=852748&clcid=0x409\r\n\r\nUse of PAID editions of this software requires separate licensing through a\r\nMicrosoft Volume Licensing program.\r\nBy choosing a PAID edition, you are verifying that you have the appropriate\r\nnumber of licenses in place to install and run this software.\r\n\r\nEnter your edition(1-8): 2\r\nThe license terms for this product can be found in\r\n\/usr\/share\/doc\/mssql-server or downloaded from:\r\nhttps:\/\/go.microsoft.com\/fwlink\/?LinkId=855862&clcid=0x409\r\n\r\nThe privacy statement can be viewed at:\r\nhttps:\/\/go.microsoft.com\/fwlink\/?LinkId=853010&clcid=0x409\r\n\r\nDo you accept the license terms? [Yes\/No]:yes\r\n\r\nEnter the SQL Server system administrator password: \r\nThe specified password does not meet SQL Server password policy requirements because it is too short. The password must be at least 8 characters\r\nEnter the SQL Server system administrator password: \r\nConfirm the SQL Server system administrator password: \r\nConfiguring SQL Server...\r\n\r\nForceFlush is enabled for this instance. \r\nForceFlush feature is enabled for log durability.\r\nCreated symlink from \/etc\/systemd\/system\/multi-user.target.wants\/mssql-server.service to \/lib\/systemd\/system\/mssql-server.service.\r\nSetup has completed successfully. SQL Server is now starting.<\/pre>\n