Connection strings for SQL Azure
Providers for SQL Azure
Community Forums
Find solutions and post questions regarding connection string related issues.
The SQL Azure Database service is only available with TCP port 1433. Ensure that your firewall allows outgoing TCP communication on TCP port 1433.<br />
<br />
SQL Azure does not support Windows Authentication. The Trusted Connection will always be set to False.<br />
<br />
SQL Azure doesn’t support unencrypted connections. You need to specify in your connection string that you want to encrypt the connection.<br />
<br />
Connecting to SQL Azure by using OLE DB is not supported.
.NET Framework Data Provider for SQL Server
Type
.NET Framework Class Library
Usage System.Data.SqlClient.SqlConnection
Manufacturer Microsoft
Usage System.Data.SqlClient.SqlConnection
Manufacturer Microsoft
Standard
Server=tcp:[serverName].database.windows.net;Database=myDataBase;User ID=[LoginForDb]@[serverName];Password=myPassword;Trusted_Connection=False;Encrypt=True;
Use 'username@servername' for the User ID parameter.
With MARS enabled
MARS was enabled in SQL Azure Service Update 2
Server=tcp:[serverName].database.windows.net;Database=myDataBase;User ID=[LoginForDb]@[serverName];Password=myPassword;Trusted_Connection=False;Encrypt=True; MultipleActiveResultSets=True;
SQL Server Native Client 10.0 ODBC Driver
Type
ODBC Driver
Usage Driver={SQL Server Native Client 10.0}
Manufacturer Microsoft
Usage Driver={SQL Server Native Client 10.0}
Manufacturer Microsoft
Standard security
Driver={SQL Server Native Client 10.0};Server=tcp:[serverName].database.windows.net;Database=myDataBase;Uid=[LoginForDb]@[serverName];Pwd=myPassword;Encrypt=yes;
Use 'username@servername' for the User ID parameter. Servername is the servername portion of the server parameter, i e 'myNamedServer' of tcp:myNamedServer.database.windows.net
SQL Server Native Client 10.0 OLE DB Provider
Type
OLE DB Provider
Usage Provider=SQLNCLI10
Manufacturer Microsoft
Usage Provider=SQLNCLI10
Manufacturer Microsoft
Selected Articles