Cannot Connect TO Name_server

Question

TITLE: Connect to Server

---

Cannot connect to Name_server.

---

ADDITIONAL INFORMATION:

Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=149; handshake=29970; (Microsoft SQL Server, Error: -2)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver--2-database-engine-error

---

Tiempo de espera de la operación de espera agotado

---

BUTTONS:

OK

---

Estimados,

hace días podía conectarme sin problemas a un servidor. sin embargo desde hace 2 días que no puedo conectar. deje texto del error arriba... estoy desesperado. Por favor su ayuda.

Answer 1

This error message suggest that you are able to reach the SQL Server instance. Or at least, you are reaching something, and we guess it is the SQL Server instance you want to connect to, but then something goes wrong. Are you connecting with Windows authentication? In such case, it may be a connection issue between SQL Server and the domain controller.

Answer 2

Hi @Brian Lizama

Here is an official document for troubleshooting the timeout expired message when connecting to SQL Server: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/timeout-expired-error?source=recommendations.

Hope this helps you.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Answer 3

Possible causes:

• SQL Server name wrong
• SQL Server not running
• Firewall blocking access
• and much more, see:

Troubleshoot connectivity issues in SQL Server