You can create a connection to a Microsoft Azure SQL database from the . This section describes how to create connections to Microsoft SQL DB.

 

Limitations

Pre-requisites

Configure

To create this connection:

For additional details on creating a SQL DB connection, see Enable Relational Connections.

This connection can also be created using the above property substitutions via CLI or API. You must create a connection of SQL Server type.

This connection is a SQL Server connection type with special settings for some properties. Please create a SQL Server connection and then modify the following properties with the listed values:

PropertyDescription
Host
Enter your hostname. Example:

 

testsql.database.windows.net
PortSet this value to 1433.
Connect String options

Please insert the following as a single string (no line breaks):

;database=<DATABASE_NAME>;encrypt=true;trustServerCertificate=false;
hostNameInCertificate=*.database.windows.net;loginTimeout=30;

where:

  • <DATABASE_NAME> is the name of the SQL DB database to which you are connecting

Tip: If you have access to the SQL DB database through the Azure Portal, please copy the Connect String from that configuration. You may omit the username and password from that version of the string.


User NameUsername to use to connect to the database.
PasswordPassword associated with the above username.
Default Column Data Type Inference

Set to disabled to prevent the from applying its own type inference to each column on import. The default value is enabled.

Use

For more information, see Database Browser.

Data Conversion

For more information on how values are converted during input and output with this database, see SQL Server Data Type Conversions.