Ports used for communication between the Qlikview and microsoft SQL server ?

[preminqlik]

hi Guys,

Can any one make me understand whenever the communication happened between the qlikview and microsoft SQL trough ODBC/OLEDB which ports are get used ...i mean through which ports they get communicated...

[Bill_Britt]

Hi,

This should be the default SQL port of 1433.

Bill

[preminqlik]

Thanks for your quick response ,

i want to just know ,in detail  , means , source ports and destination ports as well...

[preminqlik]

i mean here exactly the scenario is , data base server (may be like public) is in another domain  and qlikview environment is another domain ... what is the exact communication between them ...

[Bill_Britt · Accepted solution]

Hi,

Normally, the communication would start on port 1433. I am sure SQL would be like a webserver and once communication is  established it will move to a dynamic port.  In setting up the ODBC connector you would need to input the login information to access the SQL server in another domain.

Bill

[preminqlik]

Thanks for your info bill britt..thanks alot..

[preminqlik]

@bill my customer requesting to to set the static port for communication , is there any information about that....in detail , once communication is established it will move to a dynamic port right ... at here we can any set any static port ....?

[Bill_Britt]

HI,

The ODBC connector are not Qlik's and so this would be a question for Microsoft.  However, I don't think you can do that. The SQL server answers (I think) only on one port to start the communication and then hands it off to a dynamic port.

Bill

[preminqlik]

thanks again bill, we have checked with client network team and it is up to them i think.

this link helped me

http://support.microsoft.com/kb/287932

(here the situation is we have to access the data via internet , Microsoft automatically assigns dynamic port as you said.we are trying to open the specific port in firewall so that to communicate  )

thanks bill for your quick and valuable response. will keep updating you.