Enable remote connection to SQL Server 2005 Express

How many times did you had the following error on SQL Server 2005 Express, "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 connection". Check this post on Linglom’s blog and a step by step solution for the problem.

Another solution is to go to SQL Server Configuration Manager on Microsoft SQL Server 2005 folder at Start menu, under Configuration Tools. Select SQL Server 2005 Services, and change the State and Start Mode of SQL Server Browser item to Running and Automatic.

Hopefully it will solve your problem ;-)