MS Sql server on ubuntu

 --> Adding Repo



echo Adding Microsoft repositories... sudo curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - repoargs="$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)" sudo add-apt-repository "${repoargs}" repoargs="$(curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list)" sudo add-apt-repository "${repoargs}" echo Running apt-get update -y... sudo apt-get update -y


--> Installing MSSQL Prereq

http://security.ubuntu.com/ubuntu/pool/main/o/openssl1.0/libssl1.0.0_1.0.2n-1ubuntu5.6_amd64.deb

dpkg -i libssl1.0.0_1.0.2n-1ubuntu5.6_amd64.deb

wget http://ftp.osuosl.org/pub/ubuntu/pool/universe/j/jemalloc/libjemalloc1_3.6.0-11_amd64.deb
sudo dpkg -i libjemalloc1_3.6.0-11_amd64.deb


--> Install MSSQl
sudo apt install mssql-server


echo Running mssql-conf setup... sudo MSSQL_SA_PASSWORD="Mlinfotech@321" \ MSSQL_PID="evaluation" \
/opt/mssql/bin/mssql-conf -n setup accept-eula


--> Other Packages
sudo ACCEPT_EULA=Y apt-get install -y mssql-tools unixodbc-dev







Comments

Post a Comment

Popular posts from this blog

Nodejs,Express,Mongodb, ReactJS

Working project of MERN stack client and server both runs on differen port. Communication is REST API. No Authentication or any other stuff. https://github.com/jelorivera08/react_fullstack MogodbClient with nodejs. https://zellwk.com/blog/crud-express-mongodb/ Express.js API References https://expressjs.com/en/api.html#req.query Fullstack javascript guide. http://www.fullstackjs.com/book/
Read more

1. Understand Machine/Computer

Image
  1. Understand Machine/Computer What is Machine The computer is machine and machine is something that takes input, process and then give us output.  E.g. Water heater is machine which takes water as input and gives us hot water.  Sugarcane juice machine takes sugarcane and gives us Juice and waste as output.       Computer is also a machine that takes input from user and displays output on screen. But the heart of computer the CPU takes electricity as input and gives us back electricity.  We convert electricity into screen and show output.  Input to computer is given using Keyboard/mouse or other human operatable devices. These device convert human input to electricity and provide it as input to CPU.  Lot of hardware/software take place in between human and CUP.  Hiding the complexities of hardware from the user. Managing between the hardware's resources which include the processors, memory, data storage and I/O devices. Handling "...
Read more