- 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.
- Open Firewall TCP Port 1433 for SQL Database Engine.
- Open Firewall UDP Port 1434 for SQL Browser Service.