In order to allow your Cameyo server to communicate with a SQL instance, you need to follow the steps below. Please note that your SQL server's authentication mode needs to be SQL Server Authentication (or Mixed Mode). Windows Authentication requires both instances to be on the same domain, which is beyond the scope of this article.
- Make sure your Cameyo server has a fixed IP. If you are using a fully-hosted cloud server, our support team can do this for you.
- Make sure your SQL server has a fixed IP.
- Make sure your SQL server's firewall allows inbound traffic on the SQL port (typically 1433) to Cameyo's server, according to the address mentioned in #1.
- Configure your application to communicate with the SQL server, using the address in #2. As an example, if your SQL server's address is 35.213.312.123, the SQL connection source would look something like this: "Data Source=35.213.312.123,1433;User ID=admin;..."