Is it possible to make SQL Server to listen op port 8080

dvplayltd
dvplayltd used Ask the Experts™
on
Hi experts!

 Is it possible to make SQL Server to listen op port 8080 ? I need this, because I write WinForm application which need to communicate directly via RealIP with SQL Server and now found that in some network outbound port are not allowed and my program do not work.

Im wrong, or if user are able to open any WEB page this mean that 8080 port is open for outbound connection?

Other question is  is it possible two program to listen on same port (8080) and program to understand based of type of query that this is for it, or not for it ?

 I do not need to do this in real, but I have started FTP service on this server under Win2008 server and Im not sure that can turn off IIS for HTTP and to leave working only FTP service. Or Im wrong ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
>> Is it possible to make SQL Server to listen op port 8080 ?

Yes. You can but it is not recommended since port 8080 was often chosen as a convenient place to host a secondary or alternate web server.

>> Other question is  is it possible two program to listen on same port (8080) and program to understand based of type of query that this is for it, or not for it ?

As already mentioned, Yes. But not recommended. It may cause resource contention sometimes and unexpected errors may come out of this.

Author

Commented:

Thank you very much!
Last question - port for http is 80 or 8080 ? What number I should point to listen to SQL Server ?

I know that this is not standard, but I have problem ..appears that in Latin America most of cable ISP do not allow outbound port to his customer ... this look VERY strange to me. Then do not allow and port 21, and email port (25) ...  serious limit of use of Internet .

However, my solution is ready , probably I will redirect some of the function in WEB site, but this will need month and I'm starting NOW my solution, so I will try to use 8080 port .
well port 80 is for HTTP and often used 8080 as a alternate port so it is not a good idea to choose either of them but if you have only these two choice than I would recomend you to go for 8080.

Author

Commented:
Last question .. if user is able to open WEB page that this mean 100 % that he have right to use outbound connection with this port (80 or 8080) ?
if use can access the web page it means that your configuration is perfect, User is using port 80 for accessing your website (HTTP port) and in website data is comming from port 8080. if this is not something you are looking for than please elaborate your question more.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial