Click here to Skip to main content
15,912,578 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello All

I've an application that connects to an SQL Server somewhere in other corner of the city through Internet. Everything was working fine with following setup

1. SQL Server Installed on Windows and Firewall configured to allow connections to port 1433.

2. Router configured to connect to port 1433 from Internet.

3. DDNS Configured and being updated every 5 min. (I do not have Static IP)

This all worked well from last 3 years until recently I changed my ISP. On detailed examination I found that my previous ISP used to assign Public IP (Dynamic) to my connection where as my new ISP is assigning Private IP to my connection which is hidden behind an common IP used by ISP, thus my port is automatically blocked by ISP at its end.

So in order to connect to my SQL Server I need to purchase Static IP.

Is there any other way I can connect to my SQL Server without static IP like Team viewer does.

Thanks in advance

Amit Saraf

What I have tried:

Working on my previous ISP

1. SQL Server Installed on Windows and Firewall configured to allow connections to port 1433.

2. Router configured to connect to port 1433 from Internet.

3. DDNS Configured and being updated every 5 min. (I do not have Static IP)
Posted
Updated 30-Dec-17 1:26am

1 solution

No, unless you can persuade the hosting service to change their policy - which is unlikely.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900