Post reply

OLE DB provider "SQLNCLI11" for linked server " " returned message "Client unable to establish connection due to prelogin failure".

  • October 28, 2015 at 10:54 am

    #399239

    I unable to setup a linked server on sql server 2012. The destination server is on sql server 7.0. I can able to setup the same linked server on sql 2005 sp4 and sql 2008 r2 but unable to setup on 2012. I am getting the below error message.

    OLE DB provider "SQLNCLI11" for linked server "" returned message "Client unable to establish connection due to prelogin failure".

    Msg 10054, Level 16, State 1, Line 0

    TCP Provider: An existing connection was forcibly closed by the remote host.

    OLE DB provider "SQLNCLI11" for linked server "" returned message "Client unable to establish connection".

    Msg 26, Level 16, State 1, Line 0

    Client unable to establish connection because an error was encountered during handshakes before login. Common causes include client attempting to connect to an unsupported version of SQL Server, server too busy to accept new connections or a resource limitation (memory or maximum allowed connections) on the server.

  • October 28, 2015 at 1:20 pm

    #1836195

    Is there anyone who can help 🙂

  • October 29, 2015 at 10:39 am

    #1836454

    SQLNCLI11 is only compatible back to SQL 2005. You could try creating a linked server using and ODBC data source and use the DSN in the linked server with MSDASQL.

Viewing 3 posts - 1 through 2 (of 2 total)

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