On-premise Connections: Common Issues

Q: I have whitelisted the static IP addresses but cannot connect to my on-premise Foundation/Spectrum/Vista instance using Agave Link. How do I enable this connection?

If you have whitelisted Agave's static IP addresses and you still cannot connect, there are a few steps you can take:

Step 1: Allow Remote Connections to the Server

1. On your Windows machine, open Microsoft SQL Server Management Studio and log in:

2. Right-click on the server, and select Properties:

3. Select Connections, then check "Allow remote connections to this server":

4. Re-try authenticating with your Foundation/Spectrum/Vista credentials in Agave Link. If you are still encountering issues, try Step 2.

Step 2: Enable TCP/IP in SQL Server Configuration Manager

1. On your Windows machine, open SQL Server Configuration Manager:

2. Select **SQL Server Network Configuration Protocols for the database you are using (e.g. SAGE100CON). Right-click on TCP/IP and set to "Enabled":

3. If you have firewall rules enabled, right-click on TCP/IP and select Properties:

4. Select the IP Addresses tab, then scroll down to IPAll. Map the external port you are using for the Agave Link connection to either the "TCP Dynamic Ports" or "TCP Port" (whichever is being used for the Agave Link connection):

5. Re-try authenticating with your Foundation/Spectrum/Vista credentials in Agave Link. If you are still encountering issues, contact support@agaveapi.com.