Symptoms
The customer wanted to create smartobjects reflective of their onPrem SQL server.
Diagnoses
n/a
Resolution
1) Create a SQL Service type and connect it with your server's IP address and the open port ( you will have to open port 1433).
-The format should look like kIP Address]:sPort]
2) Set the database you wish to connect to and create the service instance.
-Note you should set your Appit instance's IP address to be on the list of permissible address to get through your firewall.
3) After creating the service instance, locate it and generate the smartobjects.
