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.

• 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.

StreamSets

• 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.

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 Private connectivity, to connect to a database that is not externalized to the internet (for example, behind a firewall), you must set up a secure connection.

Running SQL statements

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