Documentation Data Sources Direct Connection

Connect to Microsoft SQL Server

Chartio supports connecting to your SQL Server instance via a direct connection from our server to yours. For SQL Server instances hosted on Windows Azure or Amazon RDS, please refer to the instructions linked.

Check out our step-by-step video below showing you how to connect your SQL Server database to Chartio:

Currently, Chartio supports SQL authentication only. Chartio requires a read-only user for connecting to your database. To create this user, please follow our instructions for granting table level permission in SQL Server.

Chartio officially supports Microsoft SQL Server 2008 R2, 2012, 2014, and 2016. Earlier versions of SQL Server may be compatible but are not tested; therefore, support is not guaranteed.

Before you complete the connection form in Chartio, you will need to create a read-only user that Chartio can use to connect.

Select your SQL Server version from the dropdown menu and enter the necessary information in the corresponding fields. When finished, click Connect.

Connecting SQL Server from a local machine

There are a couple configurations you’ll need to make to use Chartio with a local SQL Server.

  1. Forward traffic from our external IP ( 52.6.1.1 ), on port 1433 to the internal IP address of your desktop computer.
  2. Allow access to SQL Server via the Windows firewall. For more information, refer to Microsoft’s page about configuring the Windows firewall.

If you have an IT person or a network administrator, they will know how to do this for you.

Connecting to SQL Server 2008 R2 using SSL

SQL Server 2008 R2 versions prior to 10.50.2811.0 have a bug that causes encrypted JDBC connections to fail. This issue has been resolved in SQL Server 2008 R2 Service Pack 1, Cumulative Update 6 (See KB 2653857).

If the SQL Server instance doesn’t force all connections to be encrypted (and you’re okay with not encrypting the connection), you can deselect Connect using SSL in the connection form.

If the SQL Server 2008 R2 instance is setup to force encryption, or you don’t want to turn off SSL, the only option is to upgrade to Service Pack 1, Cumulative Update 6 or greater.

How to find your version of SQL Server

Open Microsoft SQL Server Management Studio and select Help > About.

How to find if the server instance is set to force encryption:

  1. Open the SQL Server Configuration Manager.
  2. Expand SQL Server Network Configuration.
  3. Right-click on Protocols for MSSQLSERVER > Properties > Flags.
  4. If the value of ForceEncryption is set to Yes, all connections must be encrypted; otherwise, the server will reject the connection.