How to create an Azure SQL Database.

Create an Azure SQL Server

  • Go to Azure and search SQL servers
  • Click Create
  • Select/create the Resource group
  • Enter a server name
  • Select the same location as the resource group
  • Authentication method, select Use both SQL and Azure AD authentication
  • Set an Azure AD admin by searching the AD group you created above.
  • Create a server admin login/pwd
  • Networking
    • Firewall rules
    • Allow Azure services and resources to access this server
    • Set to Yes
  • Additional