Set Up Microsoft Azure SQL Server and SQL Database on Azure Cloud

This post is about learning and gaining knowledge of Azure SQL Server on Microsoft Azure Cloud.

Step 1: Navigate to Azure Portal.

Step 2: Once, in the Azure Portal click on + 'Create a resource' option from the upper left corner and search for Azure SQL.

Step 3: After login to Azure cloud Home page search “SQL Database” and Click Apply offer

Step 4: A created SQL database page will be popped up. Fill in the necessary information as follows:

· Subscription: Select your Azure subscription in which you wish to create the resource.

· Resource group: Choose the resource group where you wish to create the resource or create a new one by clicking on create new option and entering the name of your choice.

· Database name: Enter the name you wish to give to the database.

· Server: Select create new option and create a new server with a unique name in any location. Use SQL authentication and specify your name as the server admin login and a suitably complex password (for security).

Authentication Method: use SQL authentication

Username: SqlDbAdmin

Password: ************

Step 5: Next click on 'Next': Networking and on the Networking page you can configure the networking settings. For now, in the Network connectivity section select Public endpoint. Then select Yes for both options in the Firewall rules section to allow access to the database server from Azure services and our current client IP address.

Step 6: Next select 'Next': Security option to configure the security for the database. For now, set the Enable Microsoft Defender for SQL option to Not now.

Step 7: Next select Next Create: Additional Settings option to configure some additional settings for the database. For now, set the use existing data option to Sample.