Trusted_Connection and Encrypt in Azure SQL connection string?

Question

A typical Azure SQL Database connection string is as follows:

Server=[server];
Database=[database];
User ID=[user];
Password=[password];
Trusted_Connection=False;
Encrypt=True;
Connection Timeout=30;

What are the Trusted_Connection and Encrypt properties for?

If I exclude them, then I cannot connect to the database from my Azure VM service.

Community · Accepted Answer · 2017-05-23 11:58:01Z

3

Encrypt is indication that Azure SQL Database requires explicit encryption of the communication. It will refuse any unecrypted connections.

Trusted_Connection is set to explicitly confirm using of SQL Server authentication as opposed to integrated Windows Authentication (check this SO question on "What is Trusted Connection")

Both parameters are required to be set with respective values in order to successfully connect to SQL Azure.

CommunityBot

11 silver badge

answered Apr 26, 2013 at 11:50

astaykov

30.8k3 gold badges72 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1