I assume this is 64 bit sql. It worked for me in 32 bit but not 64 bit.
You must apply the instcat.sql file to the 2000 server. It is located
in the install directory of the service pack for SQL 2000 you are
running. Then 2005 64bit can talk to the 2000 32 bit server.

Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************

-----Original Message-----
From: Stephen Davey
[mailto:mssqldba-ezmlmshield-x33709235.[Email address protected]
Sent: Wednesday, January 31, 2007 10:02 AM
To: LazyDBA Discussion
Subject: Re: URGENT: Linked Server

Tracy,

I tried to link a 2005 server to 2000 server from EM 2000 and it didn't
work. However, in Server Management Studio (SMS) 2005 I could link to
the 2000 server from 2005 server. I would think you should be able to
do the same with SQL 7. In other words, connect to 2005 server in SMS
then attempt to create link to your SQL 7 server.

S. Davey (1/31)


MI DIT\Agency Services
7:30 A.M. - 4:00 P.M. ET
517.335.4237 (M- F CCC )


>>> "Tracy Posner "
<mssqldba-ezmlmshield-x62402309.[Email address protected] 01/31/07
10:13 AM >>>
Hello,

I am trying to create a linked server from SQL Server 7 to SQL Server
2005. I
am doing it through Enterprise Manager by right clicking to create a
new
linked server. Server type is SQL Server and I am using 'they will be
mapped
to' and the remote servers sa login info.



After I put in the information and login/password, I get the message '
An
error occurred while retrieving the OLE DB provider properties, are you
sure
you want to save the Linked Server Settings?'

I click Yes, to go by and then it says [SQL-DMO] Unable to connect to
the
specified server. Check the server name, login name and password. Would
you
like to continue to create the linked server? I know that I am using
all the
correct login and connection info.



If I click Yes to go by this, it creates it, but if you click on tables
under
the Server named in Linked Servers a box pops up and says Error 4:
Connection
Broken.



Can you create linked servers between SQL Server 7 and 2005? Is there
something else I need to set up?







Tracy G. Posner

Systems & Database Administrator

Maryland Institute College of Art

[Email address protected]

410-225-2563





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
****************************************************************
Confidentiality Note: The information contained in this
message, and any attachments, may contain confidential
and/or privileged material. It is intended solely for the
person(s) or entity to which it is addressed. Any review,
retransmission, dissemination, or taking of any action in
reliance upon this information by persons or entities other
than the intended recipient(s) is prohibited. If you received
this in error, please contact the sender and delete the
material from any computer.
****************************************************************

MS Sql Server LazyDBA home page