How to Get Started with SQL Server (MSSQL)

SQL Server (MSSQL) is a bit tricky to get set up properly with Zapier. Our servers run Linux and we have a fickle driver stack to properly communicate with external SQL Service instances. In many instances, it is random whether or not a certain instance will work with Zapier. Here is a short list of compatibility if everything else is set up correctly:

SQL SERVER 2005 - NOT COMPATIBLE

SQL SERVER 2008, 2008 R2 - MAYBE COMPATIBLE

SQL SERVER AZURE - MAYBE COMPATIBLE

SQL SERVER 2012, 2014 - COMPATIBLE

SQL SERVER 2016 - COMPATIBLE

The first thing you can try is adding your SQL Service instance plain. Here is what that looks like:

Connect Fields

Most importantly, you'll need to make sure your SQL Service instance is available outside your firewall to the IP address listed here.

If you are able to get your account added without errors (click the "test" button to see) congrats! Otherwise, we recommend you do the following, which has been previously tested and confirmed to work:

Set up and install an Amazon RDS SQL Server 2008 R2 instance here:
http://aws.amazon.com/rds/sqlserver/

Use the connection detailed supplied when creating the Amazon RDS SQL Server instance on Zapier here:
https://zapier.com/app/settings/authorizations/MSSQLAPI

We recommend using an external database like this because it is more secure than directly exposing your production database to the internet.

Was this article helpful?
0 out of 0 found this helpful