This topic describes the Azure SQL Database connection behavior for clients that use ADO.NET 4.5 or a later version.
Important
For information about connectivity architecture, see Azure SQL Database connectivity architecture.
Outside vs inside
For connections to Azure SQL Database, we must first ask whether your client program runs outside or inside the Azure cloud boundary. The subsections discuss two common scenarios.
Outside: Client runs on your desktop computer
Port 1433 is the only port that must be open on your desktop computer that hosts your SQL Database client application.
Inside: Client runs on Azure
When your client runs inside the Azure cloud boundary, it uses what we can call a direct route to interact with the SQL Database server. After a connection is established, further interactions between the client and database involve no middleware proxy.
The sequence is as follows:
ADO.NET 4.5 (or later) initiates a brief interaction with the Azure cloud, and receives a dynamically identified port number.
- The dynamically identified port number is in the range of 11000-11999 or 14000-14999.
- ADO.NET then connects to the SQL Database server directly, with no middleware in between.
- Queries are sent directly to the database, and results are returned directly to the client.
Ensure that the port ranges of 11000-11999 and 14000-14999 on your Azure client machine are left available for ADO.NET 4.5 client interactions with SQL Database.
- In particular, ports in the range must be free of any other outbound blockers.
On your Azure VM, the Windows Firewall with Advanced Security controls the port settings.
- You can use the firewall's user interface to add a rule for which you specify the TCP protocol along with a port range with the syntax like 11000-11999.
Version clarifications
This section clarifies the monikers that refer to product versions. It also lists some pairings of versions between products.
ADO.NET
- ADO.NET 4.0 supports the TDS 7.3 protocol, but not 7.4.
- ADO.NET 4.5 and later supports the TDS 7.4 protocol.
Related links
- ADO.NET 4.6 was released on July 20, 2015. A blog announcement from the .NET team is available here.
ADO.NET 4.5 was released on August 15, 2012. A blog announcement from the .NET team is available here.
- A blog post about ADO.NET 4.5.1 is available here.
- TDS protocol version list
- SQL Database Development Overview
- Azure SQL Database firewall
- How to: Configure firewall settings on SQL Database




