Post reply

Linked Server

  • April 29, 2008 at 6:46 am

    #185888

    Hi,

    I have 1 server with 2 SQL instances.

    SQLI1 - SQL 2000

    SQLI2 - SQL 2005

    I created a linked server on the 2005 instance to the 2000 instance.

    I am using sql authentication. When a run a script on the 2005 instance to get information from the 2000 instance, I get the following error:

    OLE DB provider "SQLNCLI" for linked server " " returned message "Communication link failure".

    Msg 4, Level 16, State 1, Line 0

    Shared Memory Provider: I/O Error detected in read/write operation [4].

    Msg 18456, Level 14, State 1, Line 0

    Login failed for user ' '.

    Can anyone please assist me on this?

    Regards

    IC

  • April 29, 2008 at 6:53 am

    #808287

    I think you should try retyping your password again. To confirm if you got your password right, try using sqlcmd or connect to enterprise studio using the login and password you are trying to use for the link.

    Sopheap

  • April 29, 2008 at 7:15 am

    #808302

    I tried that numerous times before...still does not work.

  • April 29, 2008 at 8:18 am

    #808381

    Did you verify that your password is correct?

  • April 30, 2008 at 12:35 am

    #808817

    Yes

  • April 30, 2008 at 5:33 am

    #808941

    This error usually occurs when the server to which the linked server refers is stopped. Try restarting the SQL 2000 Server instance.

    Chandrachurh Ghosh
    DBA – MS SQL Server
    Ericsson India Global Services Limited
    Quality is not an act, it is a habit.

  • May 1, 2008 at 12:44 am

    #809457

    Is the 2005 instance a x64 server, and the 2000 server 32-bit?

    There is a known issue when connecting to SQL Server 2000 from SQL Server 2005 if so. There is a fix from MS which basically involves updating a number of sprocs on the 2000 box: http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

  • May 20, 2008 at 8:32 am

    #817955

    Has a fix to this been found?

    I'm having the same issue.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 8 posts - 1 through 7 (of 7 total)

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