Just click OK, and that will grant you access to the feature above to connect to the SQL server. You will be prompt to authenticate on Microsoft Azure, and after the authentication is successful, a dialogue box to create a new firewall rule with your existing IP will be displayed. ) and provide the credentials that you defined during SQL server creation.

Type the server name (make sure to use suffix. The second method is using SQL Management Studio on your workstation. The first one is by adding a client IP and use your public IP on the SQL server. When trying to connect from home, in some cases (especially in DEV environments that you may not even be connected to the corporate network to test your code), you may want to allow your workstation to be able to connect. There are a couple of ways to connect your home computer to your Azure SQL server and database. CONNECT RAZORSQL TO MY AZURE DATABASE HOW TO This article shows how to connect to Oracle Sales using wizards in RazorSQL. Open the RazorSQL application and, in the Connections menu, select Add Connection Profile -> Other -> JDBC.

When running Azure SQL, we can use the option Firewalls and virtual networks to configure how the DB administrator and applications will have access to the SQL server and databases. In the Connection Wizard that appears, set the following properties.

Connect razorsql to my azure database