Skip to content

Latest commit

 

History

History
37 lines (23 loc) · 1.85 KB

sql-database-create-new-server-firewall-portal.md

File metadata and controls

37 lines (23 loc) · 1.85 KB

Create a server-level firewall rule in the Azure portal

  1. On the SQL server blade, under Settings, click Firewall to open the Firewall blade for the SQL server.

  2. Review the client IP address displayed and validate that this is your IP address on the Internet using a browser of your choice (ask "what is my IP address). Occasionally they do not match for a various reasons.

  3. Assuming that the IP addresses match, click Add client IP on the toolbar.

    add client IP

    [!NOTE] You can open the SQL Database firewall on the server to a single IP address or an entire range of addresses. Opening the firewall enables SQL administrators and users to login to any database on the server to which they have valid credentials.

  4. Click Save on the toolbar to save this server-level firewall rule and then click OK.

    add client IP

Tip

For a tutorial, see SQL Database tutorial: Create a server, a server-level firewall rule, a sample database, a database-level firewall rule and connect with SQL Server.