Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
desmondchew
Creator III
Creator III

Setting up a SQL server endpoint connection with a custom port

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)

 

 

Labels (1)
4 Replies
john_wang
Support
Support

Hello @desmondchew ,

Thanks for reaching out to Qlik Community!

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

Hope this helps.

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
desmondchew
Creator III
Creator III
Author

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


Thank you.
Desmond

john_wang
Support
Support

Hello @desmondchew ,

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

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!