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

Postgre setup using docker

docker run -p 8042:80 \     -e 'PGADMIN_DEFAULT_EMAIL=hmdlohar@gmail.com' \     -e 'PGADMIN_DEFAULT_PASSWORD=44544545' \     -d dpage/pgadmin4 Docker componse version: '3.1' services: db: image: postgres restart: always environment: POSTGRES_PASSWORD: example      adminer: image: adminer restart: always ports: - 8023:8080
Read more