...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Azure Data Studio is a lightweight, cross-platform data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and CosmosDB.
This guide will help you install Microsoft SQL Server 2022 with SQL Server Management Studio (SSMS).
...
| Table of Contents |
|---|
...
Installation Video
...
Download and Install Docker for Mac
Step 1: Download Docker for Mac, Go to Download Docker.
Step 2: Click on Download.
...
Install Docker
Step 1: Go to Download folder infinder. Run Docker setup file.
...
Step 2: Move the Docker to the Application folder.
...
Step 3: Wait for the installation to be done.
...
Step 4: Choose Use recommended settings (require password) option, then click Finish.
...
Step 5: Enter your “password”, then click OK.
...
Step 6: Login to Docker or signup if you don’t have an account.
...
Result: Docker will be running successfully.
...
Download SQL
Step 1: Open a Terminal window and run the following command.
| Code Block |
|---|
sudo docker pull mcr.microsoft.com/mssql/server:2019-latest |
Step 2: Run the following command to launch an instance of the Docker image you just downloaded:
...
| Code Block |
|---|
docker run -d --name sql_server_demo -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=reallyStrongPwd123' -p 1433:1433 mcr.microsoft.com/mssql/server:2019-latest |
Result: A new image will appear in the container of Docker
...
...
Download Azure Database
Step 1: Download Azure Data Studio for macOS
...
Step 2: To expand the contents of the .zip file, double-click it.
...
Step 3: To make Azure Data Studio available in Launchpad, drag the Azure Data Studio.app file to the Applications folder.
...
Result: Azure Data Studio is installed successfully.
...
Connect Azure Data Studio to SQL
Step 1: Open Azure Data Studio
...
Step 2: Create a new Connection.
...
Step 3: Enter server name “localhost”, enter username “sa” and the password you created earlier while installing SQL, then click Connect
...
Step 4: Click Enable Trust server certificate.
...
Result: You have connected to your local SQL database successfully.
...