SQL Server 2005 Express error connection issue solved


I had trouble connecting locally to SQL Server Express 2005.  I found a great post from Charlie Arehart's blog called Solving error connecting to SQL Server 2005 from CFMX 6.1/7 on Localhost but still got "Connection refused" or "Error establishing socket".  Here is specific solution for SQL Server Express 2005 after I follow everyone's helpful information: making sure Dynamic Ports was blank and port was 1433 for IPAll and IP1.  I switched most IP2 through IP7 "enabled" settings to NO.  These steps can be accomplished using SQL Server Configuration Manger, TCP/IP properties.