I followed the SQL database instructions but I still cannot connect?

If after using the Databases (SQL) instructions, you still find that you are unable to connect to Klipfolio, you might find the solution in the answers to the following questions.

  • Have you whitelisted our Klipfolio IP addresses? See the full list of Klipfolio's Whitelist IP Addresses.
  • Is your database's external IP address publicly accessible and are you able to resolve the IP address to your database server? To test internally, ping or telnet your database's IP address. If unsuccessful, check your firewall configuration.
  • For multiple instances of SQL server, check your SQL Server Configuration Manager to verify you have the correct port for the database you are connecting to. The first SQL instance uses port 1433, other instances might use a different port number.
  • Is the port open? Go to the Port forwarding tester to test your port's status.  For more information see: Port Forwarder Test. If the port is not open, it might be a bad route or the destination SQL device might not be properly configured to listen to that port.
  • For an SSH Tunnel, is the domain account valid?
  • In Klipfolio, at the connect to an SQL database page, are you entering the IP address of the database server as the Host Name? Note: The Host field should not point to the SQL Server instance, just to the local host. For example, local host, not localhostSQLEXPRESS2012
  • In Klipfolio, at the connect to an SQL database page, are you entering the actual database name in the Database field?
  • Are you using an SQL Stored Procedure? When working with Klipfolio, you cannot use temporary tables or multi selects in your Stored Procedure.

Tip: You can use a query of Select 1 to test an SQL connection.