Home Forums SQL Server 2008 SQL Server 2008 - General A network-related or instance-specific error occurred while establishing a connection to SQL Server RE: A network-related or instance-specific error occurred while establishing a connection to SQL Server

  • March 19, 2012 at 12:55 pm

    #1461304

    when you say its intermittent, is that from the same machine to the same server sometimes it will connect sometimes it wont and nothing changes in the server or app configuration? If thats the case i would guess there is a network issue. when it happens you can try to ping the server hosting the SQL instance and if the ping times out we have our culprit.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]