To define a new connection from the Connection parameter in a Microsoft Azure SQL Database format:
- Select Add Database Connection. See database-specific parameters below, as well as the section Adding a Database Connection in a Workspace in Using Database Connections The new connection can be made visible only to the current user, or can be shared among multiple users.
Note: To select an existing, previously defined connection, see the section Reusing a Database Connection in Using Database Connections
Database Connection
Microsoft Azure SQL Database (JDBC)
Name
Enter a name for the new connection.
Connection Parameters
Server
The host name of the Microsoft Azure SQL Database. (It is not necessary to specify a port if a default configuration is used.)
If you have configured your Microsoft Azure SQL Database to use a non-standard port number, you can specify this port here.
The correct syntax is:
<Host>[\<Instance>][:<port>]
Database
To initiate a database connection, enter (or browse for) the database name.
Authentication
- SQL Server Authentication: Select this option to proceed with specifying log-in credentials through the Username and Password parameters.
- Windows Authentication: Select this option when connecting through a Windows user account, and the database can validate the account name and password using the Windows principal token in the operating system. Since the user account is retrieved by Windows, the Username and Password parameters are ignored.
Username and Password
Enter the username and password to access the service.
Advanced – Specify JDBC Connection
When enabled, this parameter will allow the JDBC connection string and properties to be specified directly, in order to connect to the database.
|
Option |
Description |
|---|---|
|
Connection String |
The connection string for the database to which you are connecting. |
|
Mask Connection String |
When this option is checked (set to Yes), connection strings for database connections are masked in translation and error logs. Connection strings may contain sensitive information (for example, passwords). A masked connection string appears as: jdbc:<subprotocol>:************ When this option is unchecked (set to No), connection strings are logged in plain text. |
|
Connection Property and Value |
Name/value pairs entered here will be set in the order specified, then passed on in a Properties object when connecting to the database. They do not require manual encoding of characters that are not safe in Connection Strings. |