Category: SQL SQL Server
How to enable SQL Server Remote Connections
- Start up MSSQL Browser Service
- Right click on instance name and check “allow remote connections”
- Enable TCP in SQL Server configuration Manager, in Advance settings, make sure to specift port instead of dynamic ports
- Allow port 1433 through firewall don’t forget Windows firewall also