You are viewing limited content. For full access, please sign in.

Question

Question

DMZ Connection to Database for Lookup on Forms

asked on March 22, 2017 Show version history

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!

 

 

0 0

Replies

replied on March 22, 2017

Hi Rick,

If you're using MS SQL, it's most likely you'll need to allow coms on port 1433. Unless the default port has been changed.

Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)

 

 

1 0
replied on March 23, 2017

Ben, thank you for the suggestion.  They are going to open that port tonight after hours, I'll let you know what happens!

0 0
replied on March 24, 2017

That was it, Ben.  Thank you so much!

0 0
replied on March 24, 2017

You're welcome. Glad to help.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.