none
SQL Server 2008 R2 drops connection

    Question

  • Hi,

    We have installed a new server with Windows Server 2008 R2 with SQL Server 2008 R2. Sometimes SQL Server drops the connections :

    System.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
    

    We had the same server with the same load and the same databases on Windows Server 2008 with SQL Server 2008 and we did not have this problem.

    Thank you for your help

    Greg

    Tuesday, January 04, 2011 8:09 AM

Answers

  • Do you see any Error in SQL ERRORLOG at the same time?
    Anything in Event Log?

    Error indicates network issue.

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Tuesday, January 04, 2011 8:12 AM
    Moderator

All replies

  • Do you see any Error in SQL ERRORLOG at the same time?
    Anything in Event Log?

    Error indicates network issue.

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Tuesday, January 04, 2011 8:12 AM
    Moderator
  • I suspect that it could be about your network connections. Have you talked to your network guys about this possibility?
    Ekrem Önsoy - MCDBA, MCITP:DBA & DBD, MCSD.Net, SQL Server MVP | ekremonsoy@blogspot.com
    Tuesday, January 04, 2011 8:21 AM