Allowing Remote Access to SQL Server Express

If SQL Server Express Edition is installed using default setup options access is only permitted from the local machine. This tip explains how to enable remote access to databases via TCP/IP or named pipes to allow the creation of centralised data stores.