Set up MSSQL in Node.js

install Docker

Docker docs

use docker to install SQL Server(for mac intel chip)

1
$ sudo docker pull mcr.microsoft.com/mssql/server:2023-latest

Note : You can change the version you want by change the year of latest version

launch SQL Server image in docker

1
$ docker run -d --name sql_server_test -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=password' -p 1433:1433 mcr.microsoft.com/mssql/server:2022-latest

Note :

  • Docker command Line - Cli

install mssql cli

1
$ npm i -g sql-cli

Note : mssql-cli

use mssql-cli to test whether MSSQL install success

1
$ mssql -u sa -p password

download GUI for MSSQL - Azure Data Studio

download Azure Data Studio

MSSQL connection in Node.js

Github an example of MSSQL connection

Note : Make sure server is running in Docker containers