topic Re: Setting up a SQL server endpoint connection with a custom port in Qlik Replicate

Setting up a SQL server endpoint connection with a custom port

desmondchew — Thu, 28 Mar 2024 08:53:19 GMT

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)

Re: Setting up a SQL server endpoint connection with a custom port

john_wang — Thu, 28 Mar 2024 09:04:42 GMT

Hello @desmondchew ,

Thanks for reaching out to Qlik Community!

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

Hope this helps.

John.

Re: Setting up a SQL server endpoint connection with a custom port

john_wang — Thu, 28 Mar 2024 09:17:33 GMT

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.

Re: Setting up a SQL server endpoint connection with a custom port

desmondchew — Wed, 03 Apr 2024 03:31:21 GMT

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

Thank you.
Desmond

Re: Setting up a SQL server endpoint connection with a custom port

john_wang — Wed, 03 Apr 2024 04:05:38 GMT

Hello @desmondchew ,

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

Regards,

John.