How to configure SQL Server 2005 to allow remote connections

I seem to run into this problem far to often

Link to How to configure SQL Server 2005 to allow remote connections

posted by Aaron Fischer on Thursday, 08 February 2007 09:16:40 (Pacific Standard Time, UTC-08:00) Comments [0]
All comments require the approval of the site owner before being displayed.
Name
E-mail
(will show your gravatar icon)
Home page

Comment (Some html is allowed: a@href@title, b, blockquote@cite, em, i, strike, strong, sub, super, u) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.  

Enter the code shown (prevents robots):
Live Comment Preview