Setting up a SQL server endpoint connection with a custom port

[desmondchew]

I would like to setup a new SQL Server endpoint that uses a customize port.

How shall I specify the value under Server text box in "Manage Endpoint Connetions"?

I have attached a screenshot showing that I input as

--> 10.20.30.40,1450

(IP: 10.20.30.40, Port: 1450)

[john_wang]

Hello @desmondchew ,

Thanks for reaching out to Qlik Community!

Yes, you are right, this is the correct format.

Hope this helps.

John.

[john_wang]

Hello @desmondchew ,

The syntax and format are in MS SQL Server standard ODBC Connection string. The complete syntax for the Server keyword is as follows:

Server=[protocol:]Server[,port]

By default, SQL Server uses port 1433 which can be omitted in the connection string.

Regards,

John.

[desmondchew]

The source endpoint is using a non default SQL server port 1433. It uses port 1450. 

Thank you.
Desmond

[john_wang]

Hello @desmondchew ,

Thanks for the update. Feel free to let me know if you need any additonal information.

Regards,

John.