SQLState: 01000 SQL Server Error: 10061

Problem

Connection failed:
SQLState: 01000
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (connect())

Connection failed:
SQLState: 08001
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.


Solution:

1.Make sure that you have configured the firewall on the computer to allow this instance of SQL Server to accept connections.

2.Use the SQL Server Configuration Manager tool to allow SQL Server to accept remote connections.

Reference :

https://social.msdn.microsoft.com/forums/sqlserver/en-US/be38b076-6f62-4dce-a2cb-bd1a3bb33c6b/odbc-connection-failure