Home Forums SQL Server 2012 SQL 2012 - General Connection Failed: SQLState :'01000' SQL server error:'11001' [Microsoft] [ODBC Sql server driver] [TCP/IP sockets]ConnectionOpen (connect()). RE: Connection Failed: SQLState :'01000' SQL server error:'11001' [Microsoft] [ODBC Sql server driver] [TCP/IP sockets]ConnectionOpen (connect()).

  • Also, I have checked all of the SQL server protocols to ensure TCP/IP is running, the SQL browser is running. What is weird when I went to "check" the settings, and hadn't changed anything it started working again. This will be an intermittent problem I would like to solve.

    Thanks for the help,

    Trent