Does SQL Server 2008 express allow remote connections?

Question

I have tried to remotely connect to SQL. I put in port 1433, I restarted the service, and I don't have Windows' firewall active. However, I can only use local connection, I can't remotely connect.

I read that SQL Server 2005 Express doesn't allow remote connection, but what about 2008? Does it allow remote connections?

Answer 1

You need to setup the server to accept tcp/ip connections.

This is done through the SQL Server Configuration Manager.

Start the manager, navigate to your server node and enable TCP/IP connections on it.