- 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.
Sunday, December 6, 2009
SQL Server 2005 Remote Connectivity
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment