Is it possible to connect SQL Server via internet without opening port like teamview software ?

Question

When installing the software to connect SQL database over the internet, I have to declare to open the port to get data. I want to make this installation simple, I can rewrite the SQL Server data connection without opening the same port like temview software or Ultraview software? If so how would the code be written or there is a sample for this case ?

Answer 1

@Dong Lam trien Hi,

Thank you for posting in Q&A!

So far as I know, when you want to connect to SQL server from another computer, you must open a communication port in the firewall. The default instance of the Database Engine listens on port 1433.

May I ask what's the specific configuration of "opening the same port like temview software"? Is it achieve the same result as opening the port in the windows firewall inbund rules? The following link is about connecting SQL server from other computers.
lesson-2-connecting-from-another-computer

However, Opening ports in your firewall can leave your server exposed to malicious attacks. It is suggested that you can access SQL server via LAN or a VPN connection, but not over the internet because it's a much greater security risk. If you want applications to access a SQL database over the internet then it is generally done via a web service.

Hope you have a nice day!
Gloria

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

You do not understand my question, in my opinion that the SQL Server connection according to Microsoft standards must have a static IP, Port, user and password to connect via the Internet, this connection is like the connection of the VNC software to control the machine. from remote computer, meanwhile teamView and Ultraview software have the same function as VNC software which only uses IP, user and password to connect, you should note that teamView and UltraView software do not use a port to connect. , in this case I want to ask can you design or write code to connect SQL Server without using port like teamView or Ultraview software ?