How to resolve TCP/IP connection issue and connect to SQL Server?

​

Problem

​

Error message:

The TCP/IP connection to the host localhost, port 1433 has failed. Error: “Connection timed out: no further information.. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.

​

Solution:

1. Open SQL Server Configuration Manager => SQL Server Network Configuration =>Protocols for {Your Instance Name} and change the status to Enabled for TCP\IP protocol.
   MSSQLSERVER is the default instance name.

1. Open Services ( Ctrl + R and type services and Enter ).
2. Go to Service name SQL Server (MSSQLSERVER) (MSSQLSERVER is the default SQL Server instance name. If your instance name is different, select that instance name) and right click and restart.

1. If you try to connect to the SQL Server now, You will be able to connect to the SQL Server.