Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hello @desmondchew ,
Thanks for reaching out to Qlik Community!
Yes, you are right, this is the correct format.
Hope this helps.
John.
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.
The source endpoint is using a non default SQL server port 1433. It uses port 1450.
Thank you.
Desmond
Hello @desmondchew ,
Thanks for the update. Feel free to let me know if you need any additonal information.
Regards,
John.