Search code examples
sql-server-2008-express

Does SQL Server Express 2008 work on local networks?


I want to connect multiple clients at the same time to a specific database (eg. mydb.mdf) on SQL Server Express 2008 in a local network (LAN). Is it possible or I have to install SQL Server 2008?


Solution

  • You can have SQL Server 2008 Express have clients conect over the network. Just enable the tcp/ip and/or named pipes protocol (if not enabled) for the service and restart the service.