I seem to run into this problem far to often
Link to How to configure SQL Server 2005 to allow remote connections
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.