Uwaga
Dostęp do tej strony wymaga autoryzacji. Może spróbować zalogować się lub zmienić katalogi.
Dostęp do tej strony wymaga autoryzacji. Możesz spróbować zmienić katalogi.
Dotyczy:
SQL ServerAzure SQL DatabaseAzure SQL Managed InstanceAzure Synapse AnalyticsAnalytics 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.
Uwaga
Chociaż identyfikator Entra firmy Microsoft to nowa nazwa usługi Azure Active Directory (Azure AD), aby zapobiec zakłócaniu działania istniejących środowisk, usługa Azure AD nadal pozostaje w niektórych zakodowanych na stałe elementach, takich jak pola interfejsu użytkownika, dostawcy połączeń, kody błędów i polecenia cmdlet. W tym artykule dwie nazwy są wymienne.
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.
Ważne
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.
Dodawanie parametru
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. Na przykład ApplicationIntent=ReadOnly; InitialCatalog=WideWorldImporters.
For a complete list of parameters, see Properties.
Ostrożność
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.