Linked server between sql 2000 and 2005?

Question

Post reply

Linked server between sql 2000 and 2005?

fizzleme

SSCertifiable

Points: 6906
More actions
December 8, 2008 at 9:15 am

#77149

I'd like to establish a linked server using a sql2000 database as the host and linking to a sql2005 database. This seems a bit unlikely. Is it possible? Any gotchas? Please help.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.

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

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

Jerry Hung SSChampion Points: 12968 More actions · Answer 1

Google seemed to think so, I would think so too

I'd suggest try it first (make sure you setup the credentials/logins correctly), there is no harm

We have linked server in SQL 2005 to SQL 2000 in house, no issue

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23022479.html

SQLServerNewbieMCITP: Database Administrator SQL Server 2005

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 2

You should install the SQL 2005 native client. SQLNCI is the driver that you have to use to access SQL2005 resources. Then you can set it up as a normal linked server (using SQLNCI).

Shamless self promotion - read my blog http://sirsql.net

fizzleme SSCertifiable Points: 6906 More actions · Answer 3

This would be from sql2000 to 2005. Your link indicates the user had difficulties.

When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

Once you've accepted your flaws, no one can use them against you.

fizzleme SSCertifiable Points: 6906 More actions · Answer 4

Nicolas: That makes sense. I'll give it a shot.

When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

Once you've accepted your flaws, no one can use them against you.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 5

What's wrong? the older drivers from 2000 should work, although some of the newer features and keywords might not work.

fizzleme SSCertifiable Points: 6906 More actions · Answer 6

Steve: I was concerned the older drivers may not work. The newer features are not required. The link would be used to query the 2005 database from the 2000. So you are saying installing the native client is not necessary?

When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

Once you've accepted your flaws, no one can use them against you.