locked
Azure SQL DB Connection fails intermittently from SSMS RRS feed

  • Question

  • Hello Team,

    We are connecting to Azure SQL DB using SSMS. Our IP address has been added in the FIrewall listing of Azure Portal.

    But, we keep facing this issue intermittently where the connection to Azure SQL DB fails. some instances of the error message are as given below -

    Please suggest!

    ------------------------------

    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=348; handshake=29667;  (Microsoft SQL Server, Error: -2)

    TITLE: Connect to Server
    ------------------------------

    Cannot connect to spoazsql001.database.windows.net.

    ------------------------------
    ADDITIONAL INFORMATION:

    A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) (Microsoft SQL Server, Error: 121)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=121&LinkId=20476

    ------------------------------

    The semaphore timeout period has expired

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    Tuesday, October 27, 2020 11:10 AM

All replies

  • Hi skelkar4,
    This forum mainly talks about linq to sql. Your question is more related to Azure SQL. it is recommended to ask the question on the Microsoft Q&A forum and you can get more professional answer.
    Thank you for your understanding.
    Best Regards,
    Daniel Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, October 28, 2020 1:36 AM