Share via

Error in event viewer -SQL VERSION 2019 and windows version 2019

SM 26 Reputation points
2023-04-10T08:19:38.6633333+00:00

Need some info on the below error related Sql server..

Network error code 0x2746 occurred while establishing a connection; the connection has been closed. This may have been caused by client or server login timeout expiration. Time spent during login: total 9671 ms, enqueued 0 ms, network writes 0 ms, network reads 9670 ms, establishing SSL 0 ms, network reads during SSL 0 ms, network writes during SSL 0 ms, secure calls during SSL 0 ms, enqueued during SSL 0 ms, negotiating SSPI 0 ms, network reads during SSPI 0 ms, network writes during SSPI 0 ms, secure calls during SSPI 0 ms, enqueued during SSPI 0 ms, validating login 0 ms, including user-defined login processing 0 ms.
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,365 questions
Windows Network
Windows Network
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Network: A group of devices that communicate either wirelessly or via a physical connection.
674 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Pramod De Thabrew 5 Reputation points
    2023-04-16T05:54:09.4933333+00:00

    This error message indicates that a network error occurred while establishing a connection between the client and server. The error code 0x2746 suggests that the connection was closed due to a timeout expiration. Here are some steps you can take to troubleshoot this issue:

    1. Check the network connection: Ensure that the client and server are connected to the same network and that there are no network connectivity issues. You can try pinging the server from the client to check the network connectivity.
    2. Check the server configuration: Verify that the server is configured to accept incoming connections and that the necessary ports are open. You can check the server configuration settings and firewall rules to ensure that they are configured correctly.
    3. Check the client configuration: Verify that the client is configured to connect to the correct server and that the necessary connection settings are configured correctly. You can check the client configuration settings to ensure that they are configured correctly.
    4. Check the login timeout settings: Verify that the login timeout settings are configured correctly on both the client and server. You can adjust the login timeout settings to allow for a longer connection time.
    5. Check the SSL configuration: If SSL is being used to secure the connection, verify that the SSL configuration settings are configured correctly on both the client and server. You can check the SSL configuration settings to ensure that they are configured correctly.
    0 comments