1. Install SQL Server by opening the terminal window, and type the following:
mkdir sql
cd sql
wget -qO- https://packages.microsoft.com/keys/microsoft.asc > microsoft.asc
sudo apt-key add microsoft.asc
wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list > mssql-
sudo add-apt-repository "$(cat mssql-server-2019.list)"
sudo apt-get update
sudo apt-get install -y mssql-server
sudo /opt/mssql/bin/mssql-conf setup
Password: #############
systemctl status mssql-server --no-pager
2. I installed Azure Data Studio, which is a cross-platform and open-source desktop tool for your environments, whether in the cloud, on-premises, or hybrid. To administer SQL Server, you will need to install Azure Data Studio from this website.
In Firefox go to:
Click .deb
sudo apt install ~/Downloads/azuredatastudio-linux-1.25.1.deb
azuredatastudio
New Connection
1. Microsoft SQL Server
2. localhost
3. SQL Login
4. Username: SA
5. Password: ############
6. Connect
3. Install ms sql tools. Open the Terminal Window and type the following commands:
wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/prod.list > prod.list
sudo cp prod.list /etc/apt/sources.list.d/msprod.list
sudo add-apt-repository "$(cat prod.list)"
sudo apt-get install mssql-tools unixodbc-dev
Comments
0 comments
Please sign in to leave a comment.