How to create an azure SQL database and how to deploy azure SQL database
As part of this blog you will be able to lean the steps on how to to create and deploy azure SQL database in azure environment.
Follow the steps mentioned to create and learn the below topics.
· Azure SQL Database creation
· Cloud-based database setup
· Step-by-step guide to creating SQL Database
· Azure database management
STEP 1. Azure Portal Sign-In: Log in to the Azure Portal (https://portal.azure.com/) using your Azure account.
STEP 2. Create a Resource Group: A resource group is a logical container for Azure resources. Create a new one or use an existing resource group.
STEP 3. Search for SQL database
STEP 4. Click on create SQL database
STEP 5. Fill the necessary details under basics tab. So If you do not have existing server available create new server (Click on create new to create the server). You can also select the storage capacity for your database according to your requirements (Cost and storage capacity).
STEP 6. Select and enter all the necessary details and choose use SQL authentication if you which to login to your SQL database with user name and password. Finally click on ok to create the server.
STEP 7. Navigate to review + create tab and review all the details of your SQL database and click on create. Once you click on create your deployment begins.
STEP 8. Once you deployment of azure SQL database was completed you should see the below page. Click on got to resource to access your database.
STEP 9. Click on query editor in your overview page.
STEP 10. Enter you SQL username and password to access your SQL database.
Incase if you face any error while trying to access your database saying (Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny Public Network Access is set to Yes (https://docs.microsoft.com/azure/azure-sql/database/connectivity-settings#deny-public-network-access). To connect to this server, use the Private Endpoint from inside your virtual network (https://docs.microsoft.com/azure/sql-database/sql-database-private-endpoint-overview#how-to-set-up-private-link-for-azure-sql-database).)
You can fix the error by following the below steps.
- Navigate to overview tab and click on set server firewall.
2. Under the public access tab click on selected networks. Click on add your client IPV4 address and click on save button.
STEPS 11. Finally go to query editor tab as showed in step 10 and access your database now. You should be able to launch your SQL database and see the page as shown below.
Please let me know if you are facing any issue’s in the comments . Lets connect on LinkedIn : https://www.linkedin.com/in/madhu-narayana-varma-m-08216919a/
