How to Enable Remote Connections to SQL

How to Enable Remote Connections to SQL


This guide will walk you through enabling remote connections to SQL Server, allowing other devices on your network to connect to the database.

  1. Open SQL Server Configuration Manager
    Go to Start and search for SQL Server 2022 Configuration Manager
    Click Open
  2. Enable TCP/IP Protocol
    Expand SQL Server Network Configuration
    Click on Protocols for MSSQLSERVER
    Right-click on Named Pipes and select Enable
    Right-click on TCP/IP and select Enable
  3. Go to SQL Server Services
    Right-click on SQL Server (MSSQLSERVER)
    Select Restart
  4. To complete this setup, follow the instructions in the article:  How to Open a Port in Windows Firewall
    Note: Be sure to enter 1433 as the port number when you are asked for it.