Receiving timeout errors on SQL2014

  • Dhruva_51

    SSChampion

    Points: 10502

    Similar to the one mentioned in the below article. We are sql server build number 12.0.5589 and windows server 2012R2. Server doesn't accepts new connections and doesn't respond.

    https://support.microsoft.com/en-us/help/2919863/you-receive-time-out-error-messages-when-you-connect-to-a-sql-server-2

     

     

  • Site Owners

    SSC Guru

    Points: 80385

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • VastSQL

    SSC-Dedicated

    Points: 35720

    Did you get a chance to check the logs?(SQL Logs & Windows)

  • Sue_H

    SSC Guru

    Points: 89971

    In addition to checking the logs, you can login with the DAC and check what is going on with the system - locks, blocks, waits, system health extended events, etc.

    Sue

  • Jeff Moden

    SSC Guru

    Points: 994239

    You are more than a year behind on SQL Server cumulative updates.  I can only imagine but would suspect that you're probably behind on Windows Updates, as well.  If for no other reason, you need to update to the latest and greatest on both for security reasons.  It might also fix your current problem.

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Jeff Moden

    SSC Guru

    Points: 994239

    I know it sounds crazy but I just went through something similar just 15 minutes ago.  The problem was that the SQL Service wasn't started.  When I manually started it, it worked just fine.

    So, check to see if the SQL Server service is actually running.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Dhruva_51

    SSChampion

    Points: 10502

    services were running fine. Will look into pushing updates.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply