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

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.