MSSQL Server Installs – Enabling remote connections

Just because it gets me every time!

  • Open the Windows Firewall for the port (default port 1433) – http://msdn.microsoft.com/en-us/library/ms175043.aspx
  • Enable TCP/IP for the given server using SQL Server Configuration Manager (turned off by default)
Advertisements