SQL Server 2008 R2 Express accepts only local connections? [closed]

Coming from question SQL Server 2008 connection tagged under sql-server-2008-express

Chris S wrote in SQL Server 2008 R2 vs. SQL Server 2008 R2 Express:

  • "The biggest different I see others have missed is that Express does not accept network connections (only local ones)"

I am having difficulties to find reference where is it written. Can you give me one?

What are "network connections (only local ones)" - on the same network, in the same AD, inside the same developing machine? Can they be from the same workgroup Windows computer?


Solution 1:

It's not anywhere because you can access SQL server express from the network. It's just not turned on by default, you need to enable network connections manually.