7 Steps to enable SQL Server Remote connections

7 Steps to enable SQL Server Remote connections DOWNLOAD Enable SQL Server Remote connections Enable SQL Server Remote connections Step1: Open SQL Server Configuration Manager from: Windows Start Menu. Step2: Change the startup mode for the SQLBrowser Service to be “ Automatic ” Step3: Enable TCP/IP protocol in SQL Server Network configuration You can also enable named pipes protocol, but it’s not recommended for security reasons. Step4: Make sure that TCP ports in all IP address are “ 1433” Step5: Add firewall exceptions for the SQL Server Most of times this file can be located at “C:\Program Files\Microsoft SQL Server\MSSQL<sql version no>MSSQLSERVER\MSSQL\Binn” as an example( “ C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn”). Step6: it’s recommended to Add SQL Browser Service to the firewall exceptions It can be found most of times in this path “C:\Program Files (x86)\Microsoft SQL Serv...