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 respective instructions.
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.
Check out our step-by-step video below showing you how to connect your SQL Server database to Chartio:
1. Create a SQL Server read-only user
Currently, Chartio supports SQL authentication only. Before you complete the connection form in Chartio, you’ll need to create a read-only user that Chartio can use to connect. To create this user, please follow our instructions for granting table level permission in SQL Server.
2. Allow Chartio to connect SQL Server from a local machine
Follow the instructions in the Microsoft SQL Server section of our documentation for how to allow Chartio’s IP address.
3. Connect Microsoft SQL Server to Chartio
After creating the read-only user and allowing Chartio’s IP address, complete the Microsoft SQL Server connection form in Chartio.
Select your SQL Server version from the dropdown menu and enter the necessary information in the remaining fields.
Open Microsoft SQL Server Management Studio and select Help > About.
When finished, click Connect.
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. Check our instructions below to find whether or not your instance forces encryption.
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 if the server instance is set to force encryption:
- Open the SQL Server Configuration Manager.
- Expand SQL Server Network Configuration.
- Right-click on Protocols for MSSQLSERVER > Properties > Flags.
- If the value of ForceEncryption is set to Yes, all connections must be encrypted; otherwise, the server will reject the connection.