Posted by Nasir on 07/19/06 21:07

I'll answer my question my self:

SQL 2005 cannot connect to SQL 2000 via linked server unless SQL2k is up to
SP3 or SP4 (service pack). After applying the SP3 or 4 run the following
script:

osql -UAnAdminLogin -PAdminPassword -SComputerName -ilocation\instcat.sql
Then you can conenct after adding the linked server via sp_addlinkedserver
or GUI.

See for ref: http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

Thanks,
Nasir

"Nasir" <nmajeed@prosrm.com> wrote in message
news:44bd0d01$0$1012$39cecf19@news.twtelecom.net...
> No, I have not tried that. Can you give me the sequnce of the steps. Do I
> need to do anything on 2k-srv server side or everything needed to be done
> is on 2005 server side (just add link server on the 2k5-srv server side)?
>
>
> "Helmut Woess" <user22@inode.at> wrote in message
> news:1lxl6puanoijt.11iwl98409krs$.dlg@40tude.net...
>> Am Tue, 18 Jul 2006 10:34:21 -0500 schrieb Nasir:
>>
>>> I've a database in 2000 which needs to be accessed from 2005 via linked
>>> server. I've tried the GUI options and it is failing. One thins is that
>>> our
>>> both servers have hyphen('-' not underscore, could that be a problem) in
>>> the
>>> names, like 2k-srv and 2k5-srv as hosts, but the instances are default.
>>>
>>> Can anyone give me the steps please.
>>>
>>> TIA
>>> Nasir
>>
>> have you tried [2k-srv] instead 2k-srv ??
>>
>> bye, Helmut
>
>

[Back to original message]