Connection reference for SQL Server

You need specific information to establish a seamless and secure connection. The following fields are required, except where noted.

Connection name

Enter a new SQL Server connection name.

Connection description

Provide a short description of the connection. (Optional)

Host

Enter the host name or IP address.

Example

192.168.1.1

Port

Enter the port number associated with the SQL Server database.

User

Enter the SQL Server account username.

Password

Enter the SQL Server account password. (Optional)

Database

Specify the database associated with the account. (Optional)

Advanced Configuration

Provide additional key-value pairs that you need to set up your connection to SQL Server or customize additional JDBC parameters supported by SQL Server. When you are using an SSL certificate with SQL Server, we recommend you enter the following Key and Value pairs:

  • For Key, enter encrypt and for Value, enter true. This option specifies that the port is secured and the communication is encrypted using an SSL certificate.

  • For Key, enter trustServerCertificate, and for Value, enter true. This option specifies that the ThoughtSpot server should trust the customer SSL certificate, and is required if you are using a private SSL certificate.

Related information

Was this page helpful?
×