Flash Sale:75% Off Hosting + Free DomainEnds in13h47m14sView Plans
Hostvento logoHostvento
Get Started

Allow Remote Connections to SQL Server 2019 and Connect

This guide shows you how to let SQL Server 2019 accept connections from other computers. Then you connect to it from SSMS.

Windows Hosting2 min read22 steps21 screenshots

What does remote access mean?

SQL Server is a program that stores data. "Remote" means you reach it from another computer over the network or internet. By default, a new SQL Server often accepts only local connections. You must switch on a few settings.

Warning: Opening a database to the internet is risky. Use strong passwords. Allow only the IP addresses you trust if you can. Take a backup before changing settings. This guide needs admin rights on the server.

Part 1: Turn on TCP/IP

  1. On the server, click Start and open SQL Server 2019 Configuration Manager.
    Screenshot: On the server, click Start and open SQL Server 2019 Configuration Manager .
    Screenshot: On the server, click Start and open SQL Server 2019 Configuration Manager .
    Screenshot: On the server, click Start and open SQL Server 2019 Configuration Manager .
    Screenshot: On the server, click Start and open SQL Server 2019 Configuration Manager .
    Screenshot: On the server, click Start and open SQL Server 2019 Configuration Manager .
  2. Expand SQL Server Network Configuration.
    Screenshot: Expand SQL Server Network Configuration .
  3. Click Protocols for MSSQLSERVER. A named instance has its own name here.
  4. Right-click TCP/IP and choose Enable.
  5. Double-click TCP/IP, open the IP Addresses tab, and scroll to IPAll.
    Screenshot: Double-click TCP/IP , open the IP Addresses tab, and scroll to IPAll .
  6. Make sure TCP Port shows 1433. A port is like a numbered door on the server. 1433 is the usual door for SQL Server.
    Screenshot: Make sure TCP Port shows 1433 . A port is like a numbered door on the server. 1433 is the
    Screenshot: Make sure TCP Port shows 1433 . A port is like a numbered door on the server. 1433 is the
  7. Click OK.

Part 2: Allow remote connections in SSMS

  1. Open SSMS and connect to the server.
  2. Right-click the server name and choose Properties.
  3. Click Connections.
  4. Tick Allow remote connections to this server.
    Screenshot: Tick Allow remote connections to this server .
  5. Click OK.
  6. Right-click the server name again and choose Restart so the changes apply.
    Screenshot: Right-click the server name again and choose Restart so the changes apply.

Part 3: Open the firewall

  1. Open Windows Defender Firewall with Advanced Security.
    Screenshot: Open Windows Defender Firewall with Advanced Security .
  2. Click Inbound Rules, then New Rule.
    Screenshot: Click Inbound Rules , then New Rule .
    Screenshot: Click Inbound Rules , then New Rule .
  3. Choose Port, then TCP, and type 1433.
    Screenshot: Choose Port , then TCP , and type 1433 .
  4. Choose Allow the connection.
    Screenshot: Choose Allow the connection .
  5. Give the rule a name such as SQL Server and click Finish.
    Screenshot: Give the rule a name such as SQL Server and click Finish .
    Screenshot: Give the rule a name such as SQL Server and click Finish .
    Screenshot: Give the rule a name such as SQL Server and click Finish .

Part 4: Connect from another computer

  1. Open SSMS on your own computer.
  2. For Server name, type the server IP address, a comma, and the port. Example: 203.0.113.10,1433.
  3. Choose SQL Server Authentication.
  4. Type your login and password and click Connect.

SQL Server Authentication must be switched on in the server properties under Security. Find your server IP in your welcome email or ask Hostvento support.

Screenshot: SQL Server Authentication must be switched on in the server properties under Security . Fi

Quick recap

  • Enable TCP/IP in Configuration Manager and check port 1433.
  • Tick Allow remote connections in the server properties and restart.
    Screenshot: Tick Allow remote connections in the server properties and restart.
  • Open port 1433 in the firewall.
  • Connect from SSMS with IP, comma, port.