Edit

Connect to Server (Additional Connection Parameters page) - Database Engine

  • Article

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Use this tab to enter advanced parameters when connecting to an instance of Microsoft SQL Server Database Engine or registering Database Engine in Registered Servers. Connect and Options only appear in this dialog box when connecting to an instance of the Database Engine. Test and Save only appear in this dialog box when registering Database Engine. Access this tab by selecting Options >> on the login tab.

Note

While Microsoft Entra ID is the new name for Azure Active Directory (Azure AD), to prevent disrupting existing environments, Azure AD still remains in some hardcoded elements such as UI fields, connection providers, error codes, and cmdlets. In this article, the two names are interchangeable.

Additional parameters

The Additional Connection Parameters dialog box allows you to enter connection properties that don't have an equivalent option exposed in any other tab, usually to support an advanced scenario. The parameters entered in the Additional Connection Parameters dialog box are added to any options selected or altered in the Login and Connection Properties dialogs.

Important

Any parameters entered in this dialog box override selections made on the Login and Connection Properties dialogs. Parameters are transmitted as clear text. Don't include sensitive information in the dialog.

Add a parameter

Parameters are entered with the property name and followed by the value for the property. For scenarios that include Availability Groups, to connect to a secondary replica that supports read-intent so you can execute read-only queries, enter ApplicationIntent=ReadOnly. If you connect to an Availability Group with replicas in multiple subnets and specify the Listener in the Server name dialog on the Login page, enter MultiSubnetFailover=True for faster detection of, and connection to, the (currently) active server.

When entering multiple parameters, separate them with a semicolon. For example, ApplicationIntent=ReadOnly; InitialCatalog=WideWorldImporters.

For a complete list of parameters, see Properties.

Caution

Additional parameters aren't typically required and exist to support advanced scenarios. If you determine that a connection isn't working as expected, check the Additional Connection Parameters dialog to see if any unexpected options exist. It isn't uncommon that users enter options for testing purposes and then forget to remove them.

Related content