Rajanand's Blog

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

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

from SSMS or DBeaver

Rajanand Ilangovan's photo
Rajanand Ilangovan
Jan 18, 2022·

1 min read

Problem

You are unable to connect to SQL Server from SQL Server Management Studio or DBeaver due to TCP/IP connection issue.

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.".

tcp ip connection issue in sql server - Rajanand.png

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. sql server configuration manager - rajanand.org.png
  2. Open Services ( Ctrl + R and type services and Enter ).
  3. 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. restart sql server - rajanand.org.png
  4. If you try to connect to the SQL Server now, You will be able to connect to the SQL Server.

Check out this gif for for step by step solution.

dbeaver-sql-server-tcp-ip-connection-issue-rajanand.org.gif