none
OLE DB provider "SQLNCLI11" for linked server "\sqlexpress" returned message "Login timeout expired". [SQLSTATE 01000]

    Question

  • Processed 379 pages for database '_x_x', file '_x_x_Log' on file 1. [SQLSTATE 01000]
    BACKUP LOG successfully processed 379 pages in 0.410 seconds (7.219 MB/sec). [SQLSTATE 01000]
    BackupSetID = 1 for database '_x_x' [SQLSTATE 01000]
    RESTORE VERIFYONLY FROM DISK = 'C:\MSSQL\Backup\x\_x_x_Backup_20190415150006.trn' WITH  FILE = 1,  NOUNLOAD,  NOREWIND [SQLSTATE 01000]
    The backup set on file 1 is valid. [SQLSTATE 01000]
    End of Script [SQLSTATE 01000]
    Test Linked Server Connection: \sqlexpress [SQLSTATE 01000]
    OLE DB provider "SQLNCLI11" for linked server "\sqlexpress" returned message "Login timeout expired". [SQLSTATE 01000]
    OLE DB provider "SQLNCLI11" for linked server "\sqlexpress" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". [SQLSTATE 01000]
    Will either of the fix work?

    • Set the remote login timeout to 30 seconds, by using this code:
      sp_configure 'remote login timeout', 30
      go
      reconfigure with override
      go
    • Set the remote query timeout to 0 (infinite wait), by using this code:
      sp_configure 'remote query timeout', 0 
      go
      reconfigure with override
      go
    • or setting the Named Pipes to "Disabled"

    Monday, April 15, 2019 4:18 PM

Answers

  • It looks like you restored a database and are not trying to connect to this sql server.

    Further it looks like you are trying to connect to this sql server using \SQLExpress

    You need to connect using .\SQLExpress

    Hilary

    • Marked as answer by Avyayah Monday, April 15, 2019 10:11 PM
    Monday, April 15, 2019 5:21 PM
    Moderator