I have many processes that start on the Web Portal and are submitted anonymously, but this is the first one that uses a lookup to fill fields on an initial submission so I need a connection from the DMZ to the database. I have all the fields in the Edit Data Source configuration on the DMZ forms site set to exactly the same as on the regular forms site, yet it won't connect on the DMZ side. It keeps giving me the error "The specified SQL Server instance does not exist or access is denied. [LFF3604-InvalidSQLServerName]"
I have ensured that the dmz site is authorized to connect to the database server via ports 80, 443 and 8188. Is there anything else I need to do to enable this connection, because although the lookup works everywhere once the initial form is submitted, I really need it to work on the initial submission through the Web Portal and it's not. Any advice would be greatly appreciated, thanks!