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...Published on
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.
