On the NWC SQL Server Connection does anyone know how to configure it using a port other than 1433? This is just an example but I have tried xxx.xxxx.com:14333 and xxx.xxxx.com,1433 but I get an error in the database host column.
What sort of error are you seeing. It may be a firewall issue. Are the NWC IPs in the allow list ? https://help.nintex.com/en-US/platform/AllowlistIPAddresses.htm
I sent a link to the vendor, I’m trying to connect to which is CDATA, and they said the firewall settings there doesn’t apply. It looks like the column doesn’t allow a port. I’ve tried it with a semi-colon and comma and get the following error before hitting connect.
Hi
EDIT: Sorry! Just re-read your question. I don’t think its possible to configure for a SQL Server with a non-1433 port. That database host field validation only accepts valid domain
Just enter the host name without specifying any ports.
Database Host: www.microsoft.com
FYI, my database is set to the default 1433.
The software vendor I’m trying to connect to assigned the port to 14333 so it’s required to connect.
Hi
How about setting up a linked server?
SQL Queries can pass-thru from this SQL Server (which uses port 1433) to your vendor SQL Server.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.