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.