Logs, links, notes, recipes, ...

MS SQL Server on docker

Published by Felipe Crochik on May 19, 2018

Tags
angular ansible argocd aws dns docker docker-machine eks elasticsearch elk filebeat grafana guacamole IAM k8s kibana kubernetes lcow letsencrypt macos metricbeat microk8s mongo multipass nginx node openapi rabbitmq rancher rancheros redis registry s3 samba ssh ssl swagger typescript ubuntu vpn websocket windows windows server wireguard xip.io
Recent Posts
  • Grafana – reset admin password
  • Multipass – Remote-SSH development environment on your Mac
  • AWS Credentials
  • EKS – IAM roles
  • WireGuard VPN
Archives
  • January 2022
  • August 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • September 2019
  • May 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • July 2018
  • June 2018
  • May 2018
  • March 2018
  • January 2018
  • December 2017
  • November 2017
Meta
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Run MSSQL Express (for Development)

docker run --name mssql \
-e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=atleast8' -e 'MSSQL_PID=Express' \
-p 1433:1433 -d microsoft/mssql-server-linux:latest

Run “client”

docker exec -it mssql /opt/mssql-tools/bin/sqlcmd \
-S localhost -U sa'

(*) you will be prompted to enter the password (e.g. “atleast8“)

References

  • https://hub.docker.com/r/microsoft/mssql-server-linux/
  • https://hub.docker.com/r/microsoft/mssql-tools/
Categories: TL;DR
Tags: dockerlinuxmssql

0 Comments

Leave a Reply Cancel reply

You must be logged in to post a comment.

Related Posts

TL;DR

Grafana – reset admin password

If you have deployed grafana to your k8s cluster using the helm chart and for some reason can’t login using the password stored in the secret, this is how you reset it. The password is Read more…

TL;DR

Multipass – Remote-SSH development environment on your Mac

This is a little experiment to run ubuntu linux on your Mac using multipass to develop SPAs using a vscode Remote-SSH development environment. This is not the quickest way to setup a remote development environment Read more…

TL;DR

AWS Credentials

Get the role name wget http://169.254.169.254/latest/meta-data/iam/info will get something like: { "Code" : "Success", "LastUpdated" : "2020-03-06T20:34:08Z", "InstanceProfileArn" : "arn:aws:iam::3940394039403:instance-profile/ProfileName", "InstanceProfileId" : "kasdjaksjakjsa" } or better yet, get the role name from: wget http://169.254.169.254/latest/meta-data/iam/security-credentials It Read more…

  • Embed React app in WordPress