Remote connections to SQL Server 2005 Express

Try connecting a SQL server 2005 Express server from a remote machine, you would get an error.

Error would be something like this
============================
Message : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol)

This is because the default setting for SQL server 2005 Express allows local connections only.

For configuring the remote connections ,

1. go to the SQL Server Surface area configuration application and click on Remote connections,select Local and Remote connections
2. Restart the SQL Server service