Skip to main content

SQL Server (Windows Authentication)

Connect to Microsoft SQL Server using Windows authentication

To use this connection type within the API, use a ConnectionTypeCode of SQLSERVERV1-WINDOWS.

Variable Reference​

The following variables are supported:

  • DatabaseConnectionStringSecretName - (Required) The name of the Key Vault secret containing the connection string to the database.

  • DatabaseWindowsUsernameSecretName - (Optional) If connecting via a Windows User, the name of the Key Vault Secret containing the Windows Username to use to access the database.

  • DatabaseWindowsPasswordSecretName - (Optional) If connecting via a Windows User, the name of the Key Vault Secret containing the Windows User Password to use to access the database.

  • IntegrationRuntime - (Required) Integration Runtime to use for Copy Activity.