Posted by Erland Sommarskog on 07/18/06 19:06

Nasir (nmajeed@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]