How to create an Azure SQL Server using the Azure portal

Azure SQL Server is a virtual server for your Azure SQL databases that is managed by Microsoft.

Create an Azure SQL Server

• Log in to the Azure portal.
• Search for SQL Server in the search bar.
• Select SQL Servers from the result.

• It will open a new page, where you can check for existing servers or create a new one.
• Click on + Create.

• It will open a form to fill in all the details.
• Select Subscription under that with which you want to create SQL Server.
• Select Resource group from the drop-down menu if you have already created one; else, create a new resource group.

• Provide a unique Server name.
• Wait for it to validate the Server name.
• If it throws an error, check the error and change your Server name accordingly.
• Select the Location where your Server resides.

• Select an Authentication Method, here we are using “SQL authentication”.
• Provide Server admin login and Password.

• Configuring Networking, Additional settings, and Tags tabs are all optional. You can skip them for now or make changes according to your needs.
• Check all the details that are filled in and click on Create.
• Azure will run validation on your settings, if everything is good it will start creating a SQL Server.

• You can check the status in the Notifications tab by clicking the Notification Icon on the top right side of the portal.

• You will see the screen below once the deployment is complete.

• Click on Go to resource.
• It will take you to the SQL Server page where you can check all the things that are related to your server.
• You can also go to the page shown in image 2.