Connections

manage connection settings for azure sql database instances on the connections tab solutions reference the connection using the key managing connections adding a connection in order for the azure sql connection to function, you need to allowlist the {{jigx}} ips for your database instance using the azure portal (azure sql server instance > networking > firewall rules) click on ip allowlist in the side pane to view the {{jigx}} ips you need to allowlist click on the blue add connection button to open the add connection side pane fill in your azure sql connection settings or show schema you can add additional properties for your connection using the options section at the bottom click on the help icon to see a list of all available connection options you can include in the json schema before clicking save, click on test connection to ensure that the settings are working corectly adding a new connection updating a connection click on the connection name in the list and update the configuration settings when making changes to any setting, you must re enter the password before you can save click save removing a connection click on the remove link in the last column of a record be aware, that the functions in the solution that are referencing the connection will stop working as they cannot connect to the database connection anymore considerations creating a copy of a solution duplicates the structure of the credentials and connections, to allow for easy configuration by only having to respecify secrets