How to enable remote connections for SQL Server 2008?

How do I enable remote connections on an SQL Server 2008 installation?

I have created a rule in the windows firewall to allow traffic through port 1433, but that does not seem to be enough.

Solution 1:

SQL Server Configuration Managaer

• SQL Server Network Configuration

  • Protocols for MSSQLServer

  • Enable TCP/IP

Also in SQL server Mgmt Studio on the server

• Right click the server
• Properties
• Connections
• Make sure "Allow remote connections to this server" is checked

Solution 2:

If it's a named instance, you'll also want to set the TCP/IP port to a static value and enable that in the firewall. Otherwise it's a dynamic port, meaning it could change over time.