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:
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:
Use the connection detailed supplied when creating the Amazon RDS SQL Server instance on Zapier here:
We recommend using an external database like this because it is more secure than directly exposing your production database to the internet.