Post reply

SQL2014 Express: Cannot create Linked Server

  • April 29, 2014 at 3:49 pm

    #307095

    Have SQL2014 Express installed trying to link server to a SQL 2008 Std. Both on 64-bit machines (SQL2014 Exp is Windows 7 and SQL2012 Std is Window2008R2 server). Lots of errors for the provider no matter what one I use. Downloaded and installed SQLNCLI10 and SQLNCLI11.

    Tried an ODBC connection and that works fine.

    Tried using GUI and also sp_addLinkedServer same results.

    Error is:

    Cannot create an instanced of OLE DB provider "SQLNCLI11" for linked server xxxxx/xxxxx. Error: 7302

    the provider designation changes for each one I try but the error continues.

    This is perplexing to say the least.

  • April 29, 2014 at 5:41 pm

    #1709668

    Fixed it:

    Changed service account to Local System.

    Works fine now

    🙂

  • May 17, 2017 at 9:50 am

    #1942961

    I have a similar problem, (linking to MSSQL2008 from MSSQL2014), but it wasn't fixed by using a local user.

    see screenshot - SQLNCLI11 should support an SQL2008 server, right? Any idea what the problem is?
    An ODBC connection works flawless, both with AD and local users.

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

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