Microsoft SQL Server connection

Common connectivity

• Hostname or IP address: The hostname or IP address of the database.
• Port: The port of the database.
• Database name: The name of the database.
• Instance name: The name of the instance.
• If the Microsoft SQL Server has been set up in a domain that uses NTLM (New Technology LAN Manager) authentication, select Use Active Directory Then enter the name of the domain associated with the username and password. You can select the NTLM version to use: Default or NTLM v2.

Select Server proxy to access the Amazon S3 data source through a proxy server. Depending on its setup, a proxy server can provide load balancing, increased security, and privacy. The proxy server settings are independent of the authentication credentials and the personal or shared credentials selection. The proxy server settings cannot be stored in a vault.

• Proxy host: The proxy URL. For example, https://proxy.example.com.
• Proxy port number: The port number to connect to the proxy server. For example, 8080 or 8443.
• The Proxy username and Proxy password fields are optional.

Certificates

• Port is SSL-enabled: Enable this option if the port you have chosen is configured to accept SSL connections.
• Validate the SSL certificate: Enable this option to validate that the SSL certificate returned by the host is trusted.

Additional properties

• Query timeout

For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Federal Information Processing Standards (FIPS) compliance

This connection is FIPS-compliant and can be used on a FIPS-enabled cluster.

Running SQL statements

To ensure that your SQL statements run correctly, refer to the Transact-SQL Reference for the correct syntax.