Skip to main content

Installing MSSQL server on Ubuntu

 A good guide at 

https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver16


Key steps: 


Import the public repository GPG keys:

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -


Register the SQL Server Ubuntu repository:

sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-preview.list)"


Run the following commands to install SQL Server:

sudo apt-get update

sudo apt-get install -y mssql-server


After the package installation finishes, run mssql-conf setup and follow the prompts to set the SA password and choose your edition. 

sudo /opt/mssql/bin/mssql-conf setup


Once the configuration is done, verify that the service is running:

systemctl status mssql-server --no-pager


For remote connection open the SQL Server TCP port (default 1433) on your firewall.

At this point, SQL Server is running on your Ubuntu machine and is ready to use!

Comments

Post a Comment

Popular posts from this blog

Javascript Form Validation

It's real simple. All you need to do is call a javascript function in a html  " onsubmit " in the form tag as a javascript return, like this       <form method="post" action="dosomething.php" onsubmit="return validateForm();"> If the code completes ok, the form is then sent to the page listed in "action" http://www.w3schools.com/js/js_form_validation.asp If the function specified in the onsubmit returns false, then the form is not sent to the page mentioned in action.
Post a Comment
Read more