Search code examples
sql-serversql-server-expresssql-server-2008-express

Does SQL Server 2008 express allow remote connections?

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?

Solution

  • 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.