Home Forums SQL Server 7,2000 Administration SQL 2005 Conectivity to SQL 2000 RE: SQL 2005 Conectivity to SQL 2000

  • December 30, 2009 at 2:09 am

    #1097354

    Jarda Jirava (7/9/2009)

    Hi,

    I know, it's too late to answer your question. Hope that it helps someone other. SQL Native Client provider cannot run out-of process so what you need to do is to check AllowInProcess property in SQLNCLI Provider (in Management studio under Linked server-Providers).

    I have the same issue, but the AllowInProcess box is checked. Is there something else that needs to be configured and/or is there another cause of the error message?

    Thanks

    Lempster