Creating a repo for MSSQL solutions and guide to installation
I am using MacOS, so installation of SQL-server has to be done by running docker container. I have to tried to jot down the necessary steps to successfully run SQL-server docker container and start accessing the server through Azure Data Studio and RazorSQL.
docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=yourStrong(!)Password' -e 'MSSQL_PID=Express' -p 1433:1433 -d mcr.microsoft.com/mssql/server:2017-latest-ubuntu
user : SA
password : yourStrong(!)Password
Left (1433) : port in the host machine
Right (1433) : port to the SQL docker container
(For further reference to docker hub please follow: https://getadigital.com/blog/setting-up-sql-server-on-docker-in-mac-os/ https://www.alibabacloud.com/blog/using-python-to-connect-function-compute-to-sql-server_594411)
List all the running docker containers (check if the container is running and note the container id)
docker ps -a
After the download and installation, open the Azure Studio and start a new connection:
Connection Type: Microsoft SQL Server
Server: localhost
Username: sa
Password:yourStrong(!)Password
Hit connect and you will be able to start Azure Data Studio.
go to: https://razorsql.com/download.html
After the download and installation, open RazorSQL and start a new connection.
Connection Profile name:
login:sa
password: yourStrong(!)Password
host: localhost
Hit connect and start using Razor SQL.
NOTE: You can also use SQL Pro Studio for Macos. The installations and the connection are pretty starightforward.