SQL Server 2005 Remote Connectivity

  1. Enable remote named pipe or tcp: All programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration -> Configuration for Services and Connections -> Remote Connections, choose either enable TCP or Named Pipe or both.
  2. Open Firewall TCP Port 1433 for SQL Database Engine.
  3. Open Firewall UDP Port 1434 for SQL Browser Service.

Leave a Reply

Your email address will not be published. Required fields are marked *