Azure SQL Database and Azure SQL Managed Instance connect and query articles
Applies to:
Azure SQL Database
Azure SQL Managed Instance
The following document includes links to Azure examples showing how to connect and query Azure SQL Database and Azure SQL Managed Instance. For some related recommendations for Transport Level Security, see TLS considerations for database connectivity.
Watch this video in the Azure SQL Database essentials series for a brief connect and query overview:
Quickstarts
Quickstart | Description |
---|---|
SQL Server Management Studio | This quickstart demonstrates how to use SSMS to connect to a database, and then use Transact-SQL statements to query, insert, update, and delete data in the database. |
Azure Data Studio | This quickstart demonstrates how to use Azure Data Studio to connect to a database, and then use Transact-SQL (T-SQL) statements to create the TutorialDB used in Azure Data Studio tutorials. |
Azure portal | This quickstart demonstrates how to use the query editor to connect to a database (Azure SQL Database only), and then use Transact-SQL statements to query, insert, update, and delete data in the database. |
Visual Studio Code | This quickstart demonstrates how to use Visual Studio Code to connect to a database, and then use Transact-SQL statements to query, insert, update, and delete data in the database. |
.NET with Visual Studio | This quickstart demonstrates how to use the .NET framework to create a C# program with Visual Studio to connect to a database and use Transact-SQL statements to query data. |
.NET core | This quickstart demonstrates how to use .NET Core on Windows/Linux/macOS to create a C# program to connect to a database and use Transact-SQL statements to query data. |
Go | This quickstart demonstrates how to use Go to connect to a database. Transact-SQL statements to query and modify data are also demonstrated. |
Java | This quickstart demonstrates how to use Java to connect to a database and then use Transact-SQL statements to query data. |
Node.js | This quickstart demonstrates how to use Node.js to create a program to connect to a database and use Transact-SQL statements to query data. |
PHP | This quickstart demonstrates how to use PHP to create a program to connect to a database and use Transact-SQL statements to query data. |
Python | This quickstart demonstrates how to use Python to connect to a database and use Transact-SQL statements to query data. |
Ruby | This quickstart demonstrates how to use Ruby to create a program to connect to a database and use Transact-SQL statements to query data. |
Get server connection information
Get the connection information you need to connect to the database in Azure SQL Database. You'll need the fully qualified server name or host name, database name, and login information for the upcoming procedures.
Sign in to the Azure portal.
Navigate to the SQL Databases or SQL Managed Instances page.
On the Overview page, review the fully qualified server name next to Server name for the database in Azure SQL Database or the fully qualified server name (or IP address) next to Host for an Azure SQL Managed Instance or SQL Server on Azure VM. To copy the server name or host name, hover over it and select the Copy icon.
Note
For connection information for SQL Server on Azure VM, see Connect to a SQL Server instance.
Get ADO.NET connection information (optional - SQL Database only)
Navigate to the database pane in the Azure portal and, under Settings, select Connection strings.
Review the complete ADO.NET connection string.
Copy the ADO.NET connection string if you intend to use it.
TLS considerations for database connectivity
Transport Layer Security (TLS) is used by all drivers that Microsoft supplies or supports for connecting to databases in Azure SQL Database or Azure SQL Managed Instance. No special configuration is necessary. For all connections to a SQL Server instance, a database in Azure SQL Database, or an instance of Azure SQL Managed Instance, we recommend that all applications set the following configurations, or their equivalents:
- Encrypt = On
- TrustServerCertificate = Off
Some systems use different yet equivalent keywords for those configuration keywords. These configurations ensure that the client driver verifies the identity of the TLS certificate received from the server.
We also recommend that you disable TLS 1.1 and 1.0 on the client if you need to comply with Payment Card Industry - Data Security Standard (PCI-DSS).
Non-Microsoft drivers might not use TLS by default. This can be a factor when connecting to Azure SQL Database or Azure SQL Managed Instance. Applications with embedded drivers might not allow you to control these connection settings. We recommend that you examine the security of such drivers and applications before using them on systems that interact with sensitive data.
Libraries
You can use various libraries and frameworks to connect to Azure SQL Database or Azure SQL Managed Instance. You can then build an app by using SQL Server on Linux or Windows, or a SQL Server container on Linux.
The following table lists connectivity libraries or drivers that client applications can use from a variety of languages to connect to and use SQL Server running on-premises or in the cloud. You can use them on Linux, Windows, or in containers, and use them to connect to Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics.
Language | Platform | Additional resources | Download | Get started |
---|---|---|---|---|
C# | Windows, Linux, macOS | Microsoft ADO.NET for SQL Server | Download | |
C++ | Windows, Linux, macOS | Microsoft ODBC driver for SQL Server | Download | |
Go | Windows, Linux, macOS | Microsoft Go driver for SQL Server | Install | Get started |
Java | Windows, Linux, macOS | Microsoft JDBC driver for SQL Server | Download | |
Node.js | Windows, Linux, macOS | Node.js driver for SQL Server | Install | |
PHP | Windows, Linux, macOS | PHP SQL driver for SQL Server | Download | |
Python | Windows, Linux, macOS | Python SQL driver | Install choices: * pymssql * pyodbc |
|
Ruby | Windows, Linux, macOS | Ruby driver for SQL Server | Install |
Data-access frameworks
The following table lists examples of object-relational mapping (ORM) frameworks and web frameworks that client applications can use with SQL Server, Azure SQL Database, Azure SQL Managed Instance, or Azure Synapse Analytics. You can use the frameworks on Linux, Windows, or in containers.
Language | Platform | ORM(s) |
---|---|---|
C# | Windows, Linux, macOS | Entity Framework Entity Framework Core |
Go | Windows, Linux, macOS | GORM |
Java | Windows, Linux, macOS | Hibernate ORM |
Node.js | Windows, Linux, macOS | Sequelize ORM |
PHP | Windows, Linux, macOS | Laravel (Eloquent) Doctrine |
Python | Windows, Linux, macOS | Django |
Ruby | Windows, Linux, macOS | Ruby on Rails |
Next steps
- For connectivity architecture information, see Azure SQL Database Connectivity Architecture.
- Find SQL Server drivers that are used to connect from client applications.
- Connect to Azure SQL Database or Azure SQL Managed Instance:
- Connect and query using .NET (C#)
- Connect and query using Go
- Connect and query using Java
- Connect and query using Node.js
- Connect and query using PHP
- Connect and query using Python
- Connect and query using Ruby
- Install sqlcmd and bcp the SQL Server command-line tools on Linux - For Linux users, try connecting to Azure SQL Database or Azure SQL Managed Instance using sqlcmd.
- Retry logic code examples: