Home Forums SQL Server 2017 SQL Server 2017 - Administration How do I log into SSMS v17 on a home network? RE: How do I log into SSMS v17 on a home network?

  • December 4, 2017 at 9:26 am

    #1970552

    I usually open the firewall for 1433 on VMs/other machines. I do this with 

    netsh advfirewall firewall add rule name="SQL Server" dir=in action=allow protocol=TCP localport=1433

    Make sure that you also enable remote connections from your SQL Server. Use SQL auth.