SQL Server 2005 Remote Connectivity

Posted in Linux, SQL

  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.

Posted on By user

Leave a Reply

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