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, February 08, 2007 9:16:40 AM (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