SQL Server 2005 Not Accepting Remote Connections
If any of you have ever gotten an error stating that:
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.
This document walks you through how to fix the problem using SQL Server Surface Area Configuration tool. This is a great document explaining the fix: http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
Essentially you use the tool to enable local and remote connections; real easy fix.