A network-related or instance-specific error occurred error: 40 Error: 2 SQL server 18



  • My database is stopped, and I Get error like this :

    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) (Microsoft SQL Server, Error: 2)

    I have checked :

    • Port 1433 it is enable all over the place
    • enable TCP IP under SQL Server Configuration
    • enable logon using local system

    none of them works.

    • the least problem I encountered is when I try to Start MSSQLSERVER Services, it automatically stopped every time I press "start"

    Please someone help me. My Thanks in advance.

    I do check the error log. I have 6 files of them :

    https://drive.google.com/drive/folders/14BCgCOBGzNdsy8bgrBR4Kao0EiY4sqQc?usp=sharing



  • SQL Server crashed while recovering tempdb. Could be a storage hardware problem. Since this is TempDb you can try deleting all the TempDb database and log files and restarting. SQL server will recreate them on startup.


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2