URGENT - Link server 2005 to 2000

[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

[Helmut Woess]

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

[Nasir]

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" <us****@inode.atwrote in message
news:1l******************************@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

[Erland Sommarskog]

Nasir (nm*****@prosrm.com) writes:

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.

It could be as simple as:

sp_addlinkedserver [2k-srv]

and then you can say things like:

SELECT * FROM [2k_srv].Northwind.dbo.Customers

But it can also be more complicated if the service account for the SQL 2005
service cannot log into the SQL 2000 instance. In this case, you need to
set up login mapping with sp_addlinkedsrvlogin. You find documenation of
the latter in Books Online.


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Nasir]

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...b;en-us;906954

Thanks,
Nasir

"Nasir" <nm*****@prosrm.comwrote in message
news:44**********************@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" <us****@inode.atwrote in message
news:1l******************************@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