SQL Node Validation Error (Host is Required)

Got a message stating Validation Error (Host is Required) on the SQL error running node

The parameters entered in the DBMS were validated on Microsoft SQL Server Management Studio.

What rule should I set in MS SQL to allow Losant to access the datrabase? (I do not think the Server-level IP firewall rules will work on Losant Dynamic IP addresses).


To debug what could be going on here, we should first Verify the values on your payload. Can you include a screenshot?


To address the other problem, we don’t have a way to give you a guaranteed outbound IP address. To do this today, you could have to create a proxy within your infrastructure.

Or, depending on your use case, you may utilize Losant’s Edge Agent to read SQL within your network and send the data to Losant’s cloud using Edge Workflows. More: