Guidelines for Connecting to Azure SQL Database
Updated: February 10, 2014
Microsoft Microsoft Azure SQL Database works with third-party applications, open source, and many familiar Microsoft applications, such as WCF Data Services, ODBC, and ADO.NET.
For solutions to common customer problems with Azure SQL Database, SQL Server Data Tools, and SQL Server Management Studio, see Database Lifecycle Management.
The following is a list of general considerations that apply for any connection to Microsoft Azure SQL Database:
The Microsoft Azure SQL Database service is only available with TCP port 1433. To access a Azure SQL Database database from your computer, ensure that your firewall allows outgoing TCP communication on TCP port 1433.
Before you can connect to your Azure SQL Database server for the first time, you must use the Azure Platform Management Portal to configure the Azure SQL Database firewall. You will need to create a server-level firewall setting that enables connection attempts from your computer or Azure to Azure SQL Database server. Further, if you want to control access at the database level in your Azure SQL Database server, you must create database-level firewall rules for the required databases. For more information, see Azure SQL Database Firewall, How to: Configure the SQL Database Firewall, and How to: Configure the Database-Level Firewall Settings (Azure SQL Database).
Because some tools implement tabular data stream (TDS) differently, you may need to append the Azure SQL Database server name to the login in the connection string using the
<login>@<server>notation. In these cases, separate the login and Azure SQL Database server name with the
@symbol. For example, if your login was named
login1and the fully qualified name of your Azure SQL Database server is
servername.database.windows.net, the username parameter of your connection string should be:
login1@servername. This restriction places limitations on the text you can choose for the login name. For more information, see CREATE LOGIN (Azure SQL Database).
If you do not specify a database in the connection string, you will be connected to the master database.
USEcommand is not currently supported for switching between databases. Establish a connection directly to the target database.
Not all embedded Transact-SQL statements are supported by Microsoft Azure SQL Database. Some statements that are supported in Microsoft Azure SQL Database may not support all of the same optional parameters as SQL Server 2008. For more information about Transact-SQL support in Microsoft Azure SQL Database, see Azure SQL Database Transact-SQL Support.
You must connect to the master database to create logins and databases. The master database also has the
sys.databasesviews that you can use to view logins and databases, respectively. For more information, see Managing Databases and Logins in Azure SQL Database.
Microsoft Azure SQL Database does not support Windows Authentication. Use SQL Server authentication in your connection string.
Connecting to Microsoft Azure SQL Database by using OLE DB is not supported. However, you can connect to a SQL Server linked server with an application written with SQL Server Native Client OLE DB.
Microsoft Azure SQL Database does not support distributed transactions, which are transactions that affect several resources. For more information, see Azure SQL Database General Guidelines and Limitations.
Microsoft Azure SQL Database provides a large-scale multi-tenant database service on shared resources. In order to provide a good experience to all Microsoft Azure SQL Database customers, your connection to the service may be closed. For more information, see Connection Constraints and Connection Management in SQL Database article in the TechNet Wiki.
TasksHow to: Connect to Azure SQL Database Through ASP.NET
How to: Connect to Azure SQL Database Through WCF Data Services
How to: Connect to Azure SQL Database Using PHP
ConceptsAzure SQL Database Development
Azure SQL Database Development: How-to Topics
Azure SQL Database Tools and Utilities Support
How to: Connect to Azure SQL Database Using sqlcmd
How to: Connect to Azure SQL Database Using ADO.NET
Other ResourcesAzure SQL Database Guidelines and Limitations