{"id":842,"date":"2019-03-12T14:04:49","date_gmt":"2019-03-12T18:04:49","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=842"},"modified":"2021-09-16T14:57:29","modified_gmt":"2021-09-16T18:57:29","slug":"installing-sql-server-express-in-macos","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=842","title":{"rendered":"Installing SQL Server Express in macOS"},"content":{"rendered":"

Instructions:<\/strong><\/p>\n

    \n
  1. Open `Terminal`<\/tt>.\n
    Application\/Utilities\/Terminal.app<\/pre>\n<\/li>\n
  2. Install the Homebrew package manager system.\n
    \/usr\/bin\/ruby -e \"$(curl -fsSL https:\/\/raw.githubusercontent.com\/Homebrew\/install\/master\/install)\"<\/pre>\n<\/li>\n
  3. Test Homebrew installation.\n
    brew doctor<\/pre>\n<\/li>\n
  4. Install Docker using Homebrew.\n
    brew install docker<\/pre>\n<\/li>\n
  5. Run Docker and download the latest package of SQL Server.\n
    sudo docker pull mcr.microsoft.com\/mssql\/server:2017-latest<\/pre>\n<\/li>\n
  6. Accept the EULA (End-User Licensing Agreement) and enter a `sa`<\/tt> (system administrator) password (position shown below as `<YourStrong!Passw0rd>`<\/tt>). This is the account that will run SQL Server using port 1433 to access container `sql1`<\/tt>.\n
    sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<YourStrong!Passw0rd>' \\\r\n  -p 1433:1433 --name sql1 \\\r\n  -d mcr.microsoft.com\/mssql\/server:2017-latest<\/pre>\n<\/li>\n
  7. View all containers created. You should see container `sql1`.\n
    sudo docker ps -a<\/pre>\n<\/li>\n
  8. Connect to SQL Server in container `sql1`.\n
    sudo docker exec -it sql1 \"bash\"<\/pre>\n<\/li>\n
  9. Connect to `sqlcmd` (SQL Command).\n
    \/opt\/mssql-tools\/bin\/sqlcmd -S localhost -U SA -P '<YourNewStrong!Passw0rd>'<\/pre>\n<\/li>\n
  10. At this point, you can stop the execution of `sqlcmd`.\n
    QUIT<\/pre>\n<\/li>\n
  11. Install DBeaver Community Edition (CE).
    \nhttps:\/\/dbeaver.io\/files\/dbeaver-ce-latest-installer.pkg<\/a><\/li>\n
  12. Connect to SQL Server using a client. In this tutorial, we will cover DBeaver.<\/li>\n
  13. Run DBeaver.<\/li>\n
  14. Select `Connect to database`.In the dialog box, select `SQL Server`.\n