Installing Visual Studio Code
Download VS Code
Click the download button (it should auto-detect macOS)
It will download inside of your browser
Install VS Code
Open the downloaded file
If the browser will not let you open the file because it doesn’t have the application to open it, Drag the Visual Studio Code download outside of the browser and open it from there
Installing SQL Server Extension
Open Extensions View
In VS Code, press Cmd+Shift+X or click the Extensions icon in the left sidebar (it looks like stacked blocks)
Install SQL Server (mssql) Extension
Search for "SQL Server (mssql)"
Look for the official extension by Microsoft
Click "Install”
Connecting to SQL Server
Create a new file
Hit Cmd+n
Open Command Palette
Press Cmd+Shift+P
Create Connection
Type "MS SQL: Connect" in the textbox and select it
Select “Yes” from the textbox to set the language to SQL
Type “SQL” in the textbox and select it
Select “+ Create Connection Profile” from the textbox to create a new connection
Create Connection (Continued)
Create a Profile Name
For Connection Group, leave it on “<Default>”
For Input Type, leave it on “Parameters”
Enter the Server Name, this is unique to each company
For Trust Server Certificate, select the checkbox
For Authentication Type, select “Microsoft Entra ID – Universal with MFA Support” from the dropdown menu
Under Microsoft Account, select the Sign in box
This will bring you to a web browser that will let you sign into your Microsoft account
Once signed in, navigate back to Visual Studio Code
For Tenant ID, select “3 tenets Optimization” from the dropdown menu
Database Name can be left blank
For Encrypt, leave it as “Mandatory”
Hit Connect, then hit Open to start the authentication process
Log in to your Microsoft account
Then approve the login with MFA
You should now be connected!