SQl server is not connecting.

Vishakhan K 5 Reputation points
2024-11-05T06:25:09.55+00:00

Hi Team,

We are facing an issue with SQL Server connectivity.

We hosted windows SQL 2022 Server in Azure. and every 30 days the connection to the Database is crashing and getting this below error message.

Can anybody help on this issue?

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.) (Framework Microsoft SqlClient Data Provider)

Error Number: 258

Severity: 20

State: 0

SQL Server on Azure Virtual Machines
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 45,121 Reputation points
    2024-11-05T06:31:30.84+00:00

    The error message is raised by the client component itself, not by SQL Server.

    Could be anything network related, like a busy switch/router, hickup at your IPS or maybe Azure.

    You have to monitor your network + related components for troubleshooting.

    0 comments No comments

  2. LiHongMSFT-4306 28,351 Reputation points
    2024-11-05T06:49:17.63+00:00

    Hi @Vishakhan K

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.

    You may start up with this doc which provides some steps to help you troubleshoot this error.

    A network-related or instance-specific error occurred while establishing a connection to SQL Server.

    Best regards,

    Cosmog


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.