Skyvia and SQL Server

  • 190Views
  • Last Post 09 November 2017
0
votes
Brad Ferch posted this 08 November 2017

 I went through the instructions to conect SQL Server, but I am still having issues. Can someone help walk me through the process, or even dial in to my computer and help. 

 

Thanks in advance!

0
votes
Mariia Zaharova posted this 09 November 2017

 

We provide technical support for all Skyvia users by e-mail and at Skyvia Support Portal.

First, you need to make your SQL Server available from the Internet. As documentation states, when working with SQL Server connections, the main requirement is that your SQL Server database must be available through the Internet. If connecting to database on the local computer, it is required to allow such connections in your firewall. If connecting to a computer in the local network, it is necessary to use port forwarding.

Also, your SQL Server database will be accessed from this IP - 40.118.246.204. Probably, you should whitelist it.

Thus, please contact you system administrator to make SQL Server accessible from Internet with port forwarding.

After this you can try using the following format for the Server parameter for connecting to SQL Server through Internet:

 

Server = tcp:IP\named instance,1433

 

where

IP - is an external IP address of the computer with SQL Server

named instance - your named instance

1433 - the port, on which SQL Server is listening. 1433 is a default port. If SQL Server is listening on another port, you should change it to the corresponding one.

 

Please notify us about the results.

 

Close