Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000

(Originally posted on my personal blog.)

For those of you battling with a 64-bit SQL 2005 Server linking to 32-bit SQL 2000 Servers, here’s a handy solution. This problem has been plaguing us for a while now, and today I made it work, thanks entirely to uber1024.

Add this to your SQL Server 2000 instance:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: