[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
How to create a new SQL Azure Server

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

How to create a new SQL Azure Server


To create a SQL Azure server log in the Azure Portal here and then click on Browse as shown on below.






Select the "SQL Servers" option as shown below.






Click on "(+) Add" to create a new server.

 





Provide the Server Name, Server Admin Login, the password for that login, then scroll down on that panel.






Complete the fields required. Provide the subscription, create or use an existent resource group.

If you check the checkbox named "Allow azure services to access server" it means that anything within Azure can attempt to login to this SQL Azure server and its databases.

Once you fill all the required fields you can click on the "Create" button.

















Once Azure has finished to create the SQL Azure server, click on Refresh to see the server listed as one of your database servers.







As you can see below, the SQL Azure server has been created.

Now make a click on the name of the server.







Let's configure the firewall to allow access and accept requests from an specific IP address.


Make a cick on the Firewall icon shown on below image.






You can click on the "+ Add client IP" button to create a rule on the Firewall that will add the public IP of your actual computer to the list of IP addresses allowed to access the SQL Azure server. You can also use the "Start IP" and "End IP" fields to allow access to a range of IP addresses.






Click on the icon shown below to save the firewall rules you have just created.











 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.