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

  • 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 ?
    Monday, October 26, 2020 3:44 AM

All replies

  • You have to open the MS SQL Server port by setting a firewall rule  on the hosting computer in order for a program running on a remote computer to access the MS SQL Server database remotely. 

    I suggest that look into a database Internet hosting provider that knows how to protect MS SQL SQL Server and the computer hosting MS SQL Sever when both are exposed on the public Internet.

    Your other option is to use a Web service that does CRUD operations with the database that the remote/client computer with its program consumes and accesses the Web service.

    Monday, October 26, 2020 5:16 AM
  • 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 ?
    Wednesday, October 28, 2020 9:05 AM
  • Your questions are confusing. You don't understand  the basics of how the database engine works for local or remote communications and the ports used.

    You're not asking C# questions that this forum is dedicated  to. I suggest you post to the database forum.

    https://docs.microsoft.com/en-us/answers/products/sql-server


    • Edited by DA924x Wednesday, October 28, 2020 9:44 AM
    Wednesday, October 28, 2020 9:43 AM
  • In my opinion this is asking here because writing the SQL Server connection code does not use the same port as teamView
    Thursday, October 29, 2020 2:19 AM
  • In my opinion this is asking here because writing the SQL Server connection code does not use the same port as teamView

    I have no clue as to why you are comparing something called teamView to MS SQL Server. MS SQL Server uses Named Pipes for inter-process communication with a client program running on the same computer as MS SQL Server in order to communicate, or TCP is being used that uses a port for a remote computer running a client program to communicate with MS SQL Server in a remote fashion on the LAN or WAN. 

    The well known TCP port number  for MS SQL Server communications with a client program for remote communication  on the LAN or WAN is listed in the link, and no one deviates from the default unless one has a reason when configuring MS SQL Server, which you would be notified if the default port TCP port 1433 was not being used.

    https://www.itprotoday.com/sql-server/sql-server-tcp-and-udp-ports

    https://en.wikipedia.org/wiki/List_of_TCP_and_UDP_port_numbers

    https://www.connectionstrings.com/sqlconnection/connect-via-an-ip-address/

    The IP can be a LAN IP or a WAN IP where MS SQL Server is located. 

    Then there is a question of a network firewall protecting the ports for a computer on the network that must allow access on the network from a remote computer to the computer hosting MSSQL Server,  or there is a hosed based firewall running on the computer that is protecting the ports of the computer hosting MS SQL Server, which a firewall rule must be set to open the port on the firewall.

    Capiche?


    Thursday, October 29, 2020 6:21 AM
  • Have you used VNC software yet ? If you have not used VNC software, please try it yourself before answering this topic, this is a remote control software, VNC software uses IP, Port, User and password, after the version This version is the improved TeamView or UltraView software that no longer uses Port. Maybe you say the remote control software uses the p2p protocol while SQL Server uses tcp protocol. Temporarily I do not mention SQL Server, I will mention the issue of remote control software VNC and teamView, VNC software and teamView, these 2 softwares and operating mechanism of remote control, at Why does VNC have to open the port while teamView cannot open the port but still can run through the Internet ? In my opinion teamView also has the Port open, but the port is located on the teamView provider's server, I guess but I am not sure this problem. Have you ever learned these 2 software: VNC and teamView ? teamView uses private port TCP / UDP port 5938 of provider teamView https://www.teamviewer.com/en/trust-center/security/#:~:text=TeamViewer%20Ports&text=TeamViewer%20prefers%20to%20make%20outbound,performs%20best%20using%20this%20port

    Friday, October 30, 2020 6:46 AM
  • This is the remote desktop solution I have used in the home and work  environments.

    https://www.windows-commandline.com/launch-remote-desktop-run-command/#:~:text=Just%20open%20Run%20from%20start,work%20on%20it%20any%20time.

    The remote computer must be configured for remote connection.

    It comes with the Windows O/S professional versions.


    Friday, October 30, 2020 7:34 AM
  • https://docs.microsoft.com/en-us/answers/questions/138494/is-it-possible-to-connect-sql-server-via-internet.html
    Sunday, November 1, 2020 8:45 AM