April 29, 2008 at 6:46 am
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
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
I tried that numerous times before...still does not work.
April 29, 2008 at 8:18 am
Did you verify that your password is correct?
April 30, 2008 at 12:35 am
Yes
April 30, 2008 at 5:33 am
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
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
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