Skip to main content

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 @RichR 

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 @RichR 

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